Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
IF statements
Require
Case 1 true if a<=0.75*bc Case 2 true if a0.75*b0.75*c Error if else The IF statement doesn't like this. Maybe some AND needs to go in too though can't get the syntax right. Seasons greetings JM |
#2
|
|||
|
|||
got it. For anyone with a similar issue..
=IF(AND(W16(0.75*X16),(0.75*X16)(Y16*0.75)),"Cas e1",(IF(AND(W16<=(0.75*X16),(0.75*X16)Y16),"Case2 ","ERROR"))) "Jose Mourinho" wrote: Require Case 1 true if a<=0.75*bc Case 2 true if a0.75*b0.75*c Error if else The IF statement doesn't like this. Maybe some AND needs to go in too though can't get the syntax right. Seasons greetings JM |
#3
|
|||
|
|||
I am not sure I understand what you are trying to do, maybe something like
this? =IF(AND(A1<=0.75*B1,C10.75*B1),1,IF(AND(A10.75*B 1,0.75*C1<0.75*B1),2,NA())) Regards, Peo Sjoblom "Jose Mourinho" wrote: Require Case 1 true if a<=0.75*bc Case 2 true if a0.75*b0.75*c Error if else The IF statement doesn't like this. Maybe some AND needs to go in too though can't get the syntax right. Seasons greetings JM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 If Statements between 2 values Q | Excel Worksheet Functions | |||
4 different if statements, not working | Excel Worksheet Functions | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |