Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for "IF" condition
I need a formula for the following scenario
GROUP TYPE "A" AMOUNT "B" AMOUNT WHERE A C 2 0 C CUT 2 B P 0 3 P PASTE 3 this is the way i work with my work sheet the formula i hav been using till now is =IF(AND(A9="A",B9="C"),G9.IF(AND(A9="A",B9="P"),G1 0,0)) I use this formula under "A" AMOUNT considering the row as 9. and the same for the "B" AMOUNT jut by placing "B" at the place of "A" in the formula. But the problem here is I am able to use this formula only for 7 functions. But now i am having about 35 functions and i am unabel to use this formula. Can u please suggest me the alternative function and syntax. (can i use LOOKUP for this) Please reply me. thank u. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
Need help with a Multiply Dependent One Cell Formula | Excel Worksheet Functions | |||
3 logical condition if statement | Excel Worksheet Functions | |||
conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
Condition IF | Excel Discussion (Misc queries) |