| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrun "" (blank)
Hey guys:
I need a bit of assistance to eliminate the #Value! error message in these 2 formulas if there is no data in the cell's being calculated! Is this possible? Here are the formulas as I have them working; (1) =IF(ISERROR($G$5/12)=0,"",$G$5/12) (2) =IF($H$5="","",$V$5/COUNT($H$5:$S$5)) If so, how? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "" does not seem to give a Blank cell | Excel Discussion (Misc queries) | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
