Interesting. It seems to work when I copy and paste it back into the
workbook. I see you have another response that did work for you.
What error did you receive when you tried the formula I posted.

tj

"MichaelTM99" wrote:

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