View Single Post
 
Old 01-07-2021, 01:05 PM
madkiwi madkiwi is offline Windows 7 Office 2007
Novice
 
Join Date: Jan 2010
Posts: 11
madkiwi is on a distinguished road
Default Problem referencing a bookmark in table formula

Hi all,

I have an invoicing template that I have been using for a number of years that works pretty well and it will figure out the shipping charges based on a simple formula.

=if(c7>499.99,10.95,IF(c7>199.99,7.95,4.95))

With c7 being the product totals.

But I also have some customers that get free shipping. In a different table on the template I have used a dropdown box to choose between First Class Mail, Priority Mail, UPS, NA (for pick up items) and Free.

I'd like to have the invoice template enter "NA" in the Shipping box instead of having to click on it and type NA.

I tagged the dropdown list with the bookmark "Ship".

I modified the shipping charge formula as:

=if{Ship}="Free","NA",if(c7>499.99,10.95,IF(c7>199 .99,7.95,4.95)))

The formula result (when I Alt-F9) is "!Syntax Error, {"

I suspect it is something to do with the Content Control, but don't know how to work through that. I gave it the bookmark "Ship" but it also has it's own Tag (Shipping).

Can someone tell me what I am doing wrong?

Thanks in advance.
Reply With Quote