steven_frost 12:06 30 Mar 05
Locked

does any one know the formula for adding to % together thanks

Yoda Knight 13:25 30 Mar 05

=sum((a1..b1))/2)

???

Yoda Knight 13:26 30 Mar 05

=sum((a1..b1)/2)

???

Yoda Knight 13:26 30 Mar 05

=sum((a1..b1)/2)

???

Yoda Knight 13:26 30 Mar 05

Sumthing went wrong there ! :)

steven_frost 13:31 30 Mar 05

that don't seem right i've added 10% to 2.16% and got excel telling me 5

Yoda Knight 13:37 30 Mar 05

Hmmm, that is strange - it works if u divide 1 amount by 2, and if u add 2 amount together, but not if u perform both functions.... ????

This seems to work though:

=SUM((A1/2)+(A2/2))

Number 7 13:46 30 Mar 05

Select the cells you want to sum, right click them, select Format Cells and select Percentage.

To sum the cells either use the Autosum button on the toolbar or use =SUM(A1:E1), for example, to sum cells A1 through E1.

steven_frost 14:02 30 Mar 05

Ok this is the what i have =(100+2.16+4.775+2.76)*K3%+4.775+2.16+2.76 any advice on it

Number 7 14:16 30 Mar 05

You want to multply (100+2.16+4.775+2.76) by a percentage in K3 and then add 4.775+2.16+2.76 to the result?

If that's what you want to do then format cell K3 as a percentage.

For example, I've entered =(100+10+5)*K3 in cell A5 and the value in K3 is 10.00%.

Cell A5 displays 11.5- the right answer.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac