View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

=If((f3*1.14-(h3+k3))=0,0,"Error")

************
Anne Troy
www.OfficeArticles.com

"bruce2444" wrote in message
...
I'm trying to create a formula that if (f3)*1.14 minus (h3) minus (k3) is
greater than or equal to zero, response would be "0" but if the response
is
less than zero, response would be "Error" or some other message as a
visual
marking that (f3)*1.14 minus (h3) minus (k3) is less than zero

I tried this but get error message

=IF(F3*1.14-H3-K3=0,0, Error)