View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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