Empty cells and formula

[Pampos]

I am using this formula.

IF(D11>E11;"N";IF(D11=E11;"I"; IF(D11<E11;"H")))

Its working. But I have a provlem with the empty sells. For example,

D E
5 4 N
4 7 H
3 3 I
(empty) (empty) I
0 1 H
1 1 I

I don't want to have I if the sells are empty.

 

[Khalid NGO]

Hi,

If you need blank result when any of the 2 cells are blank then try:
=IF(OR(D11="",E11=""),"",IF(D11>E11,"N",IF(D11=E11,"I",IF(D11<E11,"H"))))

Try this if both cells are blank and you need blank:
=IF(D11&E11="","",IF(D11>E11,"N",IF(D11=E11,"I",IF(D11<E11,"H"))))

Regards,

 

[Pampos]

Hi,

If you need blank result when any of the 2 cells are blank then try:
=IF(OR(D11="",E11=""),"",IF(D11>E11,"N",IF(D11=E11,"I",IF(D11<E11,"H"))))

else:
=IF(D11&E11="","",IF(D11>E11,"N",IF(D11=E11,"I",IF(D11<E11,"H"))))

Regards,

No one of them is working.

 

[Khalid NGO]

No one of them is working.

Oh i forgot to mention, you need to replace the comma "," with semicolon ";"


=IF(OR(D11="";E11="");"";IF(D11>E11;"N";IF(D11=E11;"I";IF(D11<E11;"H"))))

=IF(D11&E11="";"";IF(D11>E11;"N";IF(D11=E11;"I";IF(D11<E11;"H"))))

 

[Pampos]

Oh i forgot to mention, you need to replace the comma "," with semicolon ";"


=IF(OR(D11="";E11="");"";IF(D11>E11;"N";IF(D11=E11;"I";IF(D11<E11;"H"))))

=IF(D11&E11="";"";IF(D11>E11;"N";IF(D11=E11;"I";IF(D11<E11;"H"))))

Thanks!

 

[bosco_yip]

Oh i forgot to mention, you need to replace the comma "," with semicolon ";"


=IF(OR(D11="";E11="");"";IF(D11>E11;"N";IF(D11=E11;"I";IF(D11<E11;"H"))))

=IF(D11&E11="";"";IF(D11>E11;"N";IF(D11=E11;"I";IF(D11<E11;"H"))))

I think the last "IF condition" can be removed,

=IF(OR(D11="";E11="");"";IF(D11>E11;"N";IF(D11=E11;"I";"H")))

=IF(D11&E11="";"";IF(D11>E11;"N";IF(D11=E11;"I";"H")))

Regards
Bosco