IF statements

[Jose Mourinho]

Require
Case 1 true if a<=0.75*b>c
Case 2 true if a>0.75*b>0.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

 

[Jose Mourinho]

got it. For anyone with a similar issue..

=IF(AND(W16>(0.75*X16),(0.75*X16)>(Y16*0.75)),"Case1",(IF(AND(W16<=(0.75*X16),(0.75*X16)>Y16),"Case2","ERROR")))

 

[Peo Sjoblom]

I am not sure I understand what you are trying to do, maybe something like
this?

=IF(AND(A1<=0.75*B1,C1>0.75*B1),1,IF(AND(A1>0.75*B1,0.75*C1<0.75*B1),2,NA()))


Regards,

Peo Sjoblom