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
|
|||
|
|||
IF Formula HELP!!
I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00.
I worked out the formula in EXCEL, but I can't work it out in WORD. Please help. =IF(B23/B24=0,"0.00",B23/B24) This gives me syntax error in word. Melanie |
#2
|
|||
|
|||
IF Formula HELP!!
Hi,
Try coding your formula field as: {=IF(B24=0,0,B23/B24) \# "0.00"} For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "Swtmelly" wrote in message ... I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00. I worked out the formula in EXCEL, but I can't work it out in WORD. Please help. =IF(B23/B24=0,"0.00",B23/B24) This gives me syntax error in word. Melanie |
#3
|
|||
|
|||
IF Formula HELP!!
I can't get it to work, I've heard about ctrl F9 to get the brackets -
doesn't work in table/formula. What am I doing wrong? "macropod" wrote: Hi, Try coding your formula field as: {=IF(B24=0,0,B23/B24) \# "0.00"} For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "Swtmelly" wrote in message ... I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00. I worked out the formula in EXCEL, but I can't work it out in WORD. Please help. =IF(B23/B24=0,"0.00",B23/B24) This gives me syntax error in word. Melanie |
#4
|
|||
|
|||
IF Formula HELP!!
Hi Swtmelly,
This approach most certainly does work in tables! -- Cheers macropod [MVP - Microsoft Word] "Swtmelly" wrote in message ... I can't get it to work, I've heard about ctrl F9 to get the brackets - doesn't work in table/formula. What am I doing wrong? "macropod" wrote: Hi, Try coding your formula field as: {=IF(B24=0,0,B23/B24) \# "0.00"} For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "Swtmelly" wrote in message ... I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00. I worked out the formula in EXCEL, but I can't work it out in WORD. Please help. =IF(B23/B24=0,"0.00",B23/B24) This gives me syntax error in word. Melanie |
Thread Tools | |
Display Modes | |
|
|