If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




!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! 
Ads 
#2




!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




!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! 
Thread Tools  
Display Modes  

