Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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!
 
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 26th 06 11:30 PM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 10:16 PM


All times are GMT +1. The time now is 08:44 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"