akumar61

[akumar61]

Cany anyone tell me how to phrase following

If value in cell1<2.2 and value in cell2 is 1, return
If value in cell1>2.2 and value in cell2 is 0, return
If value in cell1 is blank, return blan

Thank

anand

 

[JE McGimpsey]

one way:

=IF(A1="","",IF(AND(A1<2.2,A2=1),1,IF(AND(A1>2.2,A2=0),0,"doesn't
meet criteria")

Note that you've left these of potential cases undefined:

A1=2.2
A1<2.2, A2<>1
A1>2.2, A2<>0

 

[Niek Otten]

And what in all the possible other cases?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel