Thanks Niek... that worked!! I had no invisible decimals (that I could
see). Is there a way I can get that message to display in a yellow popup
help or notify window?

Thanks again!

- Michael T M

"Niek Otten" wrote:

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