If then question

[EllenM]

Hello,
I'd like to write an error notice for our time sheets. I'd like to warn the
user that if
A1>24, then he needs to use A1-24 hours of leave which otherwise will be lost.

Thanks in advance,
Ellen

 

[Dave Peterson]

How about putting a formula in B1:
=if(a1<=24,"","You need to use: "&text(a1-24,"#,##0")&" hours or lose them!")

Format it in big red letters.

 

[EllenM]

Thanks, Dave. It worked!! And yes I'll format it in big red letters.
(hehehehe)