If then question
Thanks, Dave. It worked!! And yes I'll format it in big red letters.
(hehehehe)
"Dave Peterson" wrote:
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
|