Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Wrong syntax
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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" 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wrong syntax | Excel Discussion (Misc queries) | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |