How to create a formula with multiple (IF) conditions

[jimmy]

HEllo,

Could you please help me creating a formula with multiple conditions?

IF "A3" greater than 100 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 150, then ("A3"*"A5"-"A9");
IF "A3" greater than 151 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 300, then ("A3"*"A5"-"A9");

Thanks for your help

 

[Jacob Skaria]

Jimmy

Since the results are all same..there is no need of conditions...

If this post helps click Yes

 

[stanleydgromjr]

jimmy,

The *then ("A3"*"A5"-"A9")* is the same for all 4 lines.

Try:
=IF(AND(A3>100,A3<=300),(A3*A5)-A9,"not in range")


Have a great day,
Sta

 

[Jacob Skaria]

Just one IF will do...

=IF(AND(A3>100,A3<=300),A3*(A5-A9),"")

OR

=IF(AND(A3>100,A3<=300),(A3*A5)-A9,"")

If this post helps click Yes

 

[Brad]

Just to note
assume a3 = 5
assume a5 = 4
assume a9 = 2
=A3*(A5-A9) = 5*(4-2) = 5*2 = 10
=(A3*A5)-A9 = (5*4)-2 = 20-2= 18
I'm assuming that you know this already