Need Formula

  • Thread starter Thread starter DaveR
  • Start date Start date
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

(e-mail address removed)
 
=(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
|
| (e-mail address removed)
|
|
 
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

(e-mail address removed)
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
 
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
 
Back
Top