Need help with a formula

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.

{ 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" wrote in message
...
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.

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?

"Doug Robbins - Word MVP" wrote:

{ 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" wrote in message
...
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.

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

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



jlandes84 wrote:
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?

"Doug Robbins - Word MVP" wrote:

{ 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" wrote in message
...
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.

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?

"Graham Mayor" wrote:

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

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



jlandes84 wrote:
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?

"Doug Robbins - Word MVP" wrote:

{ 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" wrote in message
...
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.

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" wrote in message
...
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?

"Graham Mayor" wrote:

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

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



jlandes84 wrote:
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?

"Doug Robbins - Word MVP" wrote:

{ 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" wrote in message
...
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.

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

"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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?

"Graham Mayor" wrote:

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

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



jlandes84 wrote:
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?

"Doug Robbins - Word MVP" wrote:

{ 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" wrote in message
...
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.