View Single Post
  #5   Report Post  
MichaelTM99
 
Posts: n/a
Default

Thanks for the post. I couldn't get that one to work though... I appreciate
your reply however... thanks.

"tjtjjtjt" wrote:

Try this one:

=IF((F23+J28)-F29<80,"The Total does not equal 80 Hours. Is this
Correct?",(F23+J28)-F29)

tj

"MichaelTM99" wrote:

My formula isn't working... :(

=IF((F23+J28)-F29)<80,"The Total does not equal 80 Hours. Is this
Correct?",(F23+J28)-F29))

What am I missing? Or have I added something that shouldn't be there?
I am adding to cells, and then subtracting one. I want the Total cell to
equal what it is, but if it's not equal to 80, then to display the message
from above. My syntax has to be bad... Any help is appreciated! THANK
YOU!!!!!

--
Michael T M