| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel formulas
I have entered a
formula,=IF((OR(E21="",C21="")),0,IF((E21<C21),((E 21-C21)*24)+24,(E21-C21)*24))+IF((OR(I21="",F21="")),0,IF((I21<F21),(( I21-F21)*24)+24,(I21-F21)*24)) in timecards but I would like it to leave cell blank if there are no enteries,how do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
| Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Threaded Mode
