Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Formula doesn't work if the result is ZERO?
I'm building a form in Word 2003 and adding code to the bookmarked fields to
perform calculations One example would be: =(Gross1)*(Rate1)/100 The problem I'm having is that the latter part of the form towards the total builds upon previous calculations and all seems to come to screeching halt (the form doesn't tally) if the result of any of the previous sections is ZERO or a Non Entry. Specifically my problem is that one formula does this: =(Emod)*(PremiumTotal) But sometimes there IS no Emod so it is ZERO. If that is the case that field shows ZERO (but there is a number in PremiumTotal) With the resulting ZERO in that field, I can't finish the rest of my form. Help!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Form Fields - Can you Export to Excel Spreadsheet? | Microsoft Word Help | |||
Form for work; never done | Microsoft Word Help | |||
macrobuttons and protected document | Microsoft Word Help | |||
macro doesn't work when I unprotect form | Formatting Long Documents | |||
How do I get a formula "=SUM(ABOVE)" to work in a protected WORD . | Microsoft Word Help |