Multiple IF conditions

mckzach · Sep 22, 2005

I give up! How can I convert the following 1-2-3 formula for my Excel sheet:

@IF(EH10<>""#AND#EF10<>""#AND#EH10-EF10<.0001,1,"")

I'm thinking I need multiple AND statements, but can't get it to work. Any
help at all would be appreciated.

Duke Carey · Sep 22, 2005

=if(and(EH10<>"",EF10<>"",EH10-EF10<.0001),1,"")

Morrigan · Sep 22, 2005

You need

IF(AND(EH10<>"",EF10<>"",EH10-EF10<.0001),1,"")

Multiple IF conditions

mckzach

Duke Carey

Morrigan