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

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.

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

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.

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

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.

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

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.

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.

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

Hi Jerry

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

--
Regards

Roger Govier


"JerryBear" wrote in message
...
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.