Hi Michael,

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

But are you sure there are no invisible decimals in the cells? Format as
General to check.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"MichaelTM99" wrote in message
...
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