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

[Guest]

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.

 

[Roger Govier]

Hi

Try
=IF(B1,IF(A1<=135,20,A1*15%),0)

 

[Guest]

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

 

[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

 

[Guest]

Got it! Thanks!

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

 

[Roger Govier]

Hi Jerry

You're welcome. Thanks for letting me know you got it working.