Wrong syntax

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?

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


"Asta" <Asta@discussions.microsoft.com> wrote in message
news:826E52BD-354A-4766-BF8F-8A15A9656664@microsoft.com...
> 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 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 :-)
----------------------------------------------------------------------------

"Asta" <Asta@discussions.microsoft.com> wrote in message
news:826E52BD-354A-4766-BF8F-8A15A9656664@microsoft.com...
> 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?