use a check box to dermine shipping charges of non-stock items
Got it! Thanks!
"Roger Govier" wrote:
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
--
Regards
Roger Govier
"JerryBear" wrote in message
...
Thanks!
I tried that formula, but then I get a "compile error" and a "syntax
error"
and no result. Any ideas?
"Roger Govier" wrote:
Hi
Try
=IF(B1,IF(A1<=135,20,A1*15%),0)
--
Regards
Roger Govier
"JerryBear" wrote in message
...
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.
|