Need help with a formula

[jlandes84]

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.

 

[Doug Robbins - Word MVP]

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

--
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

 

[jlandes84]

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?

 

[Graham Mayor]

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"}

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[jlandes84]

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?

 

[Doug Robbins - Word MVP]

Select the cell and press F9 to update the fields.

--
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

 

[jlandes84]

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