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
|