steven_frost 12:06 30 Mar 2005
Locked

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

Yoda Knight 13:25 30 Mar 2005

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

???

Yoda Knight 13:26 30 Mar 2005

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

???

Yoda Knight 13:26 30 Mar 2005

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

???

Yoda Knight 13:26 30 Mar 2005

Sumthing went wrong there ! :)

steven_frost 13:31 30 Mar 2005

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

Yoda Knight 13:37 30 Mar 2005

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 2005

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 2005

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 2005

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires