If then question
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 wrote:
Hello,
I'd like to write an error notice for our time sheets. I'd like to warn the
user that if
A124, then he needs to use A1-24 hours of leave which otherwise will be lost.
Thanks in advance,
Ellen
--
Dave Peterson
|