If then question
 

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

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

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