View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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