Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
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? | Page Layout | |||
Need a formula | Microsoft Word Help |