| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leaving Cell Blank
How can this be modified to leave the cell that contains the following
expression blank if D7 is blank? Currently, if D7 is blank then "0" is returned. = (G7-D7+(G7<D7) )*24 -- Thanks, Ron |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving Cell Blank
=if(d7="","",(G7-D7+(G7<D7))*24)
Ron A. wrote: How can this be modified to leave the cell that contains the following expression blank if D7 is blank? Currently, if D7 is blank then "0" is returned. = (G7-D7+(G7<D7) )*24 -- Thanks, Ron -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving Cell Blank
Thank you!
-- Ron "Dave Peterson" wrote: =if(d7="","",(G7-D7+(G7<D7))*24) Ron A. wrote: How can this be modified to leave the cell that contains the following expression blank if D7 is blank? Currently, if D7 is blank then "0" is returned. = (G7-D7+(G7<D7) )*24 -- Thanks, Ron -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving Cell Blank. | Excel Worksheet Functions | |||
| sumif function leaving a blank cell when criteria not met | Excel Worksheet Functions | |||
| Leaving a cell blank | New Users to Excel | |||
| Leaving a cell blank when there is an error message - HELP | Excel Discussion (Misc queries) | |||
| Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
![Ron A.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
