Need help with a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jlandes84 - 15 Jan 2008 08:28 GMT

I'm getting a zero divide message as a result of clearing a table that I use
every football season.

I know why I'm getting the message, but what I want to know is how can I get
it to show 0 until the cells below get updated after the start of next season?

Here is the current formula using the formula box: =F3/SUM(C3:E3)

As always, any help is greatly appreciated. Thanks.

Reply to this Message

Doug Robbins - Word MVP - 15 Jan 2008 09:07 GMT

{ IF { SUM (C3:E3) } = 0 0 { = F3/SUM{C3:E3) } }

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm getting a zero divide message as a result of clearing a table that I
> use
[quoted text clipped - 8 lines]
>
> As always, any help is greatly appreciated. Thanks.

Reply to this Message

jlandes84 - 15 Jan 2008 10:05 GMT

I tried that, but when I entered it in the formula box, where it displayed
"!zero divide" went blank and didn't indicate that there was any kind of a
formula there when I checked the cell.

Any ideas?

> { IF { SUM (C3:E3) } = 0 0 { = F3/SUM{C3:E3) } }
>
[quoted text clipped - 10 lines]
> >
> > As always, any help is greatly appreciated. Thanks.

Reply to this Message

Graham Mayor - 15 Jan 2008 11:40 GMT

Enter it directly into the cell using CTRL+F9 for each pair of field
brackets.
You could alternatively use
{IF {=F3/SUM(C3:E3)} <> "!Zero*" "{=F3/SUM(C3:E3)}" "0"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I tried that, but when I entered it in the formula box, where it
> displayed "!zero divide" went blank and didn't indicate that there
[quoted text clipped - 24 lines]
>>>
>>> As always, any help is greatly appreciated. Thanks.

Reply to this Message

jlandes84 - 15 Jan 2008 20:15 GMT

I'm doing something wrong but I haven't found it yet.

When I tied it directly, I either saw what you suggested or the cell went
completely blank again without any sign of a formula being in place.

Is there something that you do once you enter it into the cell like you do
in Excel?

> Enter it directly into the cell using CTRL+F9 for each pair of field
> brackets.
[quoted text clipped - 29 lines]
> >>>
> >>> As always, any help is greatly appreciated. Thanks.

Reply to this Message

Doug Robbins - Word MVP - 15 Jan 2008 22:13 GMT

Select the cell and press F9 to update the fields.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm doing something wrong but I haven't found it yet.
>
[quoted text clipped - 37 lines]
>> >>>
>> >>> As always, any help is greatly appreciated. Thanks.

Reply to this Message

jlandes84 - 16 Jan 2008 06:32 GMT

That was it! Thanks Doug and Graham for all your help.

> Select the cell and press F9 to update the fields.
>
[quoted text clipped - 39 lines]
> >> >>>
> >> >>> As always, any help is greatly appreciated. Thanks.

Reply to this Message