akumar61

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
And what in all the possible other cases?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top