Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Need help with a formula
{ 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. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Need help with a formula
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. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Need help with a formula
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. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Need help with a formula
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. |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Need help with a formula
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. |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Need help with a formula
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula | Tables | |||
Formula | Tables | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
Formula Help | Microsoft Word Help | |||
Formula help? | Page Layout |