PDA

View Full Version : Excel Help

Big Bill
03-29-2007, 03:53 PM
Anyone,

I'm having a tough time remembering how to come up with a formula and would appreciate any help.

I want to enter a number in Column A, another number in Column B, and have the difference between them expressed as a percentage (out to 1 point right of the decimal) in Column C and whether the change was positive or negative, i.e., + or -.

If the number in A is smaller than the number in B, I want the percentage shown as a +, and if the number in A is greater than the number in B, I want the percentage shown with the - sign.

If anyone can give me the formula to enter in Column C for that calculation I would appreciate it greatly.

Big Bill
ryesteve
03-29-2007, 04:09 PM
B/A-1
Big Bill
03-29-2007, 04:32 PM
B/A-1

rye,

Close, but not what I need. Maybe I didn't explain my need accurately enough.
For example, I want to enter 1181 in column A, and 1462 in Column B. I then want to show in Columb C the increase of 281 expressed as shown below:

+23.8

That's the difference (281) divided 1181 which on a calculator comes out to
.23793954. I would likd to round up to +23.8. If the numbers in A and B were reversed, difference of 281 would be the decrease from 1462 and it should be shown as -19.2.

Does that help?

Big Bill
ryesteve
03-29-2007, 04:40 PM
Then either convert it to a % format, or multiply it by 100
headhawg
03-29-2007, 05:09 PM
B/A-1Simple. Very nicely done!
K9Pup
03-29-2007, 05:13 PM
rye,

Close, but not what I need. Maybe I didn't explain my need accurately enough.
For example, I want to enter 1181 in column A, and 1462 in Column B. I then want to show in Columb C the increase of 281 expressed as shown below:

+23.8

That's the difference (281) divided 1181 which on a calculator comes out to
.23793954. I would likd to round up to +23.8. If the numbers in A and B were reversed, difference of 281 would be the decrease from 1462 and it should be shown as -19.2.

Does that help?

Big Bill

=(B1-A1)/A1

format C1 as percentage and specify the number of decimal places you want.
Big Bill
03-29-2007, 06:00 PM
K9Pup,

Those steps did everything I needed. I'm greatful to all who responded.

Big Bill
K9Pup
03-30-2007, 09:22 AM
K9Pup,

Those steps did everything I needed. I'm greatful to all who responded.

Big Bill

No problem!! Heck that was an easy one. :)
raybo
04-07-2007, 12:49 PM
No problem!! Heck that was an easy one. :)

Yup, wish they were all that easy!