Wrong syntax

[Guest]

I have created this: =IF(AND(C4>300,C4<400),(C4-43)*0.36,"")
but i'd like to add more in the greater,Smaller than category and on each
add different subtractions and multiplication. How would i do such a thing?

 

[Arvi Laanemets]

Hi

The straightforward solution is:
=IF(condition1,response1,IF(condition2,response2,IF(...,...,...)))
You can have up to 7 nested IF's in such a way, i.e. 8 different responses.
Conditions are checked in order from outermost to innermost.
Usually there are ways to compose formulas for greater number of different
conditions too, but they heavily depend on real situation - no general
solutions exist.


Arvi Laanemets

I have created this: =IF(AND(C4>300,C4<400),(C4-43)*0.36,"")
but i'd like to add more in the greater,Smaller than category and on each
add different subtractions and multiplication. How would i do such a

thing?

 

[Ken Wright]

Arvi has given you one solution, but if you post your conditions and there
is a logical pattern to them then someone will often come up with something
a lot smaller and far more scalable.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have created this: =IF(AND(C4>300,C4<400),(C4-43)*0.36,"")
but i'd like to add more in the greater,Smaller than category and on each
add different subtractions and multiplication. How would i do such a

thing?