use a check box to dermine shipping charges of non-stock items

J

JerryBear

Hi,
I'm trying to use a "check box" to add shipping charges to an estimate form.
If the check box = "true" then shipping is added. Here's where I'm getting
stuck: I charge $20 shipping for items under $135 or add 15% for items over
$135 only if I don't have the item in stock. The item price is in A1, the
"check box" is in B1 and the result is in C1. Any help would be greatly
appreciated.
 
J

JerryBear

Thanks!
I tried that formula, but then I get a "compile error" and a "syntax error"
and no result. Any ideas?
 
R

Roger Govier

Hi Jerry

I gave you a formula result to add to cell C1 on your sheet, not to add
to any VBA code.
Works fine for me where the check box is linked to cell B1
 
J

JerryBear

Got it! Thanks!

Roger Govier said:
Hi Jerry

I gave you a formula result to add to cell C1 on your sheet, not to add
to any VBA code.
Works fine for me where the check box is linked to cell B1
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

allocate shipping and handling to varying number of items in an or 0
Adding Shipping Charges to Invoices (calcualated amount) 0
How would I add "shipping charge" to an Invoice (form/subform) ? 4
Finding a record based on user input 5
adding stock items to accounting reports 0
How to use two drop-down list to fill data 2
Reading a list of names to update their records 1
Check Box & Filter or not 2

Top