=if(ISERROR(F37/SUM(F37:F38)),"-",F37/SUM(F37:F38))
would be my choice
Also I would replace the "-" with a 0 so math is not interupted unless that
is your goal.
www.bleifeldcpa.com
http://thehumbleaccountant.blogspot.com/
"מיכאל (מיקי) אבידן" wrote:
Try this one: =IF(ISERR(F37/SUM(F37:F38)),"-",F37/SUM(F37:F38))
Micky
"Cassie Rodgers" wrote:
I have the following formula in cells for future months. I would like to
hide he divo result for months wihout data.
my formula is =F37/SUM(F37:F38)
I tried to enter this as =IF(ERROR(F37/SUM(F37:38)),"-",F37/SUM(F37:38) as I
found in online help. This formula does not work either.
Can anyone give me the correct formula to hide the divo error message for my
formula?
--
Cassie