| 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 | |||
Linear Mode
