Multiple IF conditions

[mckzach]

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.

[Morrigan]

You need

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

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]

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

"mckzach" wrote:

> 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.