| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement to Display word on Time
I am tyring this:
=IF(D40:00:01,"Word 1",IF(D40:01:00,"Word 2",IF(D40:05:00,"Word 3",""))) When the user puts in a time in Cell D4 - I want it to display in D5 I get errrors on this time.. How would I go about this? Appreciate any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you display IF statement results in a different cell | Excel Worksheet Functions | |||
| How do you display IF statement results in a different cell | Excel Worksheet Functions | |||
| IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| How can I create an IF statement in Excel that uses the word "con. | Excel Worksheet Functions | |||
Threaded Mode
