You need

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


Quote Originally Posted by 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.