Hi

The straightforward solution is:
=IF(condition1,response1,IF(condition2,response2,I F(...,...,...)))
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


"Asta" wrote in message
...
I have created this: =IF(AND(C4300,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?