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

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

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