Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
I'm building an order form where I'd like to include a formula that if a cell
equals a certain state then sales tax will be charged to the grand total and I have no idea So for example: I'm trying to build the formula from cell H29 =if C10=NV then I'd like the sum (H28*G29) if any other ST shows up then no sales tax would apply and the cell would equal 0 this is my first post; please redirect me if excel programming is not correct -- Thanks! Liz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
What you want is something like:
=IF(C9="NV",H28*G29,0) Excel programming is an o.k. place to post. If all you need is a formula, it will be supplied. If you need programming, that will be offered as well. -- Gary''s Student - gsnu200748 "Liz" wrote: I'm building an order form where I'd like to include a formula that if a cell equals a certain state then sales tax will be charged to the grand total and I have no idea So for example: I'm trying to build the formula from cell H29 =if C10=NV then I'd like the sum (H28*G29) if any other ST shows up then no sales tax would apply and the cell would equal 0 this is my first post; please redirect me if excel programming is not correct -- Thanks! Liz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
THANK YOU VERY VERY MUCH!!
-- Thanks! Liz "Gary''s Student" wrote: What you want is something like: =IF(C9="NV",H28*G29,0) Excel programming is an o.k. place to post. If all you need is a formula, it will be supplied. If you need programming, that will be offered as well. -- Gary''s Student - gsnu200748 "Liz" wrote: I'm building an order form where I'd like to include a formula that if a cell equals a certain state then sales tax will be charged to the grand total and I have no idea So for example: I'm trying to build the formula from cell H29 =if C10=NV then I'd like the sum (H28*G29) if any other ST shows up then no sales tax would apply and the cell would equal 0 this is my first post; please redirect me if excel programming is not correct -- Thanks! Liz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |