Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Question | Excel Discussion (Misc queries) | |||
PMT question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Question about {} | Excel Worksheet Functions |