| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display result depending on value entered
I want a quick way to enter a time in a cell.
example: F5 can either be 00:45 or 00:30 If the value 1 is entered into G5 then F5 will return 00:45 and if the value 2 is entered into G5 then F5 will return 00:30 what formula do I need for F5 Thank you, your help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to add depending upon value entered | Excel Worksheet Functions | |||
| Formula to display text depending upon date entered in a cell | Excel Worksheet Functions | |||
| Colouring a row depending on data entered in a column | Excel Worksheet Functions | |||
| Formula is entered but will not display result | Excel Worksheet Functions | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
Threaded Mode
