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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrun "" (blank)
Is formula 2 dependent on formula 1?
Just remove the =0 portion from formula 1 or flip the value_if_true and value_if_false arguments if you intentionally want it to work that way: =IF(ISERROR($G$5/12),"",$G$5/12) =IF(ISERROR($G$5/12)=0,$G$5/12,"") Biff "Jay" wrote in message ... 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, |
Reply |
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) |