Need Formula

[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)

 

[J.E. McGimpsey]

one way:

B9: =SUM(B2:B4,B8)*1.125

 

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

 

[DaveR]

Thanks Ken & J E.
Both formulas worked beautifully.
Dave

 

[Ronald W. Roberts]

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)

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

 

[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