How do you do a formula for this?

**ozmike** · 04-27-2005, 08:29 AM

Hi,
I have a excel like this:

A B C D

1 MAKE BEFORE AFTER

2 Audi 154 340

3 Toyota 165 350

I want D to be the percentage difference between column B and C and used the following formula in D2 =SUM(100/(B2/(C2-B2))
That gives me the right answer in D2 but for D3 I have to change the formula to read 3 instead of 2 and to do this for many rows is not very efficient. Is there a formula I can use to make column D read for the corresponding rows in colum B and C all the way down.
Sorry if this is a really dumb simple question but Im pretty new at this and not real good at maths

thanks.

**Domenic** · 04-27-2005, 08:56 AM

Enter the following formula in D2 and copy down:

=((C2-B2)/B2)*100

To copy the formula to other cells...

1) Select D2

2) Edit > Copy

3) Select cells to which you wish to copy

4) Edit > Paste

Hope this helps!

**ozmike** · 04-27-2005, 12:33 PM

Thanks the formula works but I still have to change it with each number ie. B2 must become B3 next line down. Is there a way I can use algebra like Bx then next line is Bx+1 or something???

**Domenic** · 04-27-2005, 01:46 PM

If you follow the instructions I gave you in order to copy the formula to other cells, you'll find that the formula in D3 becomes...

=((C3-B3)/B3)*100

Isn't that what you're looking for?

**ozmike** · 04-28-2005, 09:45 AM

sorry my fault. Thanks a lot that works great. How can I get it to round up to the nearest whole number since im getting percentages like 19.99697 etc etc.
thanks heaps