If then question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EllenM - 27 Feb 2007 23:59 GMT

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

Reply to this Message

Dave Peterson - 28 Feb 2007 00:17 GMT

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.

> Hello,
> I'd like to write an error notice for our time sheets. I'd like to warn the
[quoted text clipped - 3 lines]
> Thanks in advance,
> Ellen

Signature

Dave Peterson

Reply to this Message

EllenM - 28 Feb 2007 14:03 GMT

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

> How about putting a formula in B1:
> =if(a1<=24,"","You need to use: "&text(a1-24,"#,##0")&" hours or lose them!")
[quoted text clipped - 8 lines]
> > Thanks in advance,
> > Ellen

Reply to this Message