| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make invoice take items off stocklist in excel workbook | Excel Worksheet Functions | |||
| check occurrence of items in a range | Excel Worksheet Functions | |||
| check occurrence of items in a range | Excel Discussion (Misc queries) | |||
Linear Mode
