Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
cottage6 cottage6 is offline
external usenet poster
 
Posts: 9
Default !Zero Divide Error

I'm getting a divide by zero error using this formula =B3/C3. I read the
response from Doug Robbins saying to type the formula directly into the table
cell; the formula in the response was { IF { SUM (C3:E3) } = 0 0 { =
F3/SUM{C3:E3) } }, using Ctrl + F9 for each set of field brackets. I tried
adapting my formula as {If(B3/C3)=0 0 (B3/C3)} which didn't work. I tried
{If{(B3/C3)}=0 0 {(B3/C3)}} which didn't work either. What am I doing wrong?
Also, is there any way to assign a macro to a drawn object in Word? TIA!
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default !Zero Divide Error

Hi cottage6,

Try:
{=IF(C3=0,0,B3/C3)}

I don't quite understand what you mean by "assign a macro to a drawn object". Perhaps you could elaborate in a new thread.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"cottage6" wrote in message ...
I'm getting a divide by zero error using this formula =B3/C3. I read the
response from Doug Robbins saying to type the formula directly into the table
cell; the formula in the response was { IF { SUM (C3:E3) } = 0 0 { =
F3/SUM{C3:E3) } }, using Ctrl + F9 for each set of field brackets. I tried
adapting my formula as {If(B3/C3)=0 0 (B3/C3)} which didn't work. I tried
{If{(B3/C3)}=0 0 {(B3/C3)}} which didn't work either. What am I doing wrong?
Also, is there any way to assign a macro to a drawn object in Word? TIA!

  #3   Report Post  
Posted to microsoft.public.word.tables
cottage6 cottage6 is offline
external usenet poster
 
Posts: 9
Default !Zero Divide Error

Thank you, Thank you, Thank you!!!!! I will ask about the macro assignment
in another thread.

"macropod" wrote:

Hi cottage6,

Try:
{=IF(C3=0,0,B3/C3)}

I don't quite understand what you mean by "assign a macro to a drawn object". Perhaps you could elaborate in a new thread.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"cottage6" wrote in message ...
I'm getting a divide by zero error using this formula =B3/C3. I read the
response from Doug Robbins saying to type the formula directly into the table
cell; the formula in the response was { IF { SUM (C3:E3) } = 0 0 { =
F3/SUM{C3:E3) } }, using Ctrl + F9 for each set of field brackets. I tried
adapting my formula as {If(B3/C3)=0 0 (B3/C3)} which didn't work. I tried
{If{(B3/C3)}=0 0 {(B3/C3)}} which didn't work either. What am I doing wrong?
Also, is there any way to assign a macro to a drawn object in Word? TIA!


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
divide a page in two Fox Hills New Users 6 May 12th 23 08:47 AM
Divide page into 4 AYJ Page Layout 1 October 11th 07 10:19 AM
how do you divide the page into cards Azn kAskA Page Layout 2 July 23rd 07 11:01 AM
divide-by box FieldTripMama Microsoft Word Help 10 December 27th 06 12:30 AM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 11:16 PM


All times are GMT +1. The time now is 11:42 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"