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

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

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

=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

You are attempting to mix 2007 IFERROR function with 2003 ISERROR function.

Stick with one version or the other.

2007 =IFERROR(F37/SUM(F37:F38),"-")

2003 =IF(ISERROR(F37/SUM(F37:F38)),"-",F37/SUM(F37:F38))


Gord Dibben MS Excel MVP

On Wed, 9 Dec 2009 14:31:44 -0800, 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?