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
|