Need Formula

D

DaveR

Hi,
I'm hoping someone can help with a formula that will add a number of cells
together giving a total in cell b9.ie: =sum(b2,b3,b4,b8)
But in the same total I need to add 12.5% sales tax. I know I can do this in
a separate cell ie: =b9/100*12.5
but I have to have it in one total as I don't need or want the sales tax to
show anywhere in the page.
Any help on this would be really appreciated as I have tried everything.

Thanks
Dave

[email protected]
 
K

Ken Russell

=(sum(b2:b4)+b8)*1.125

--
Ken Russell

|
| Hi,
| I'm hoping someone can help with a formula that will add a number of cells
| together giving a total in cell b9.ie: =sum(b2,b3,b4,b8)
| But in the same total I need to add 12.5% sales tax. I know I can do this
in
| a separate cell ie: =b9/100*12.5
| but I have to have it in one total as I don't need or want the sales tax
to
| show anywhere in the page.
| Any help on this would be really appreciated as I have tried everything.
|
| Thanks
| Dave
|
| [email protected]
|
|
 
R

Ronald W. Roberts

DaveR said:
Hi,
I'm hoping someone can help with a formula that will add a number of cells
together giving a total in cell b9.ie: =sum(b2,b3,b4,b8)
But in the same total I need to add 12.5% sales tax. I know I can do this in
a separate cell ie: =b9/100*12.5
but I have to have it in one total as I don't need or want the sales tax to
show anywhere in the page.
Any help on this would be really appreciated as I have tried everything.

Thanks
Dave

[email protected]
Click to expand...

I think you can also do it this way. As an example, put the percent in A1.
This way you can change the percent and not have to cahnge the formula
in B9.
=SUM(B2:B4,B8)+(SUM(B2:B4,B8)*(A1/100))

Ron
 
D

DaveR

Hi Ronald.
That's a good one, which also gives you the option to change the % cell at a
later date.
I like that and its really appreciated.
Thanks Dave
 
Top