Donate SIGN UP
Home > Technology > Excel Functions

Excel Functions

Avatar Image
milly143 | 15:56 Wed 09th Feb 2011 | Technology
6 Answers
Aaahhh. Used to be so good with Excel and it's all gone from my mind.

Have set up a spreadsheet to compare prices from two suppliers. I want to include two sums but can't work out which functions to use. One sum is to work out the difference in pounds between the two prices and the next is to work out the difference as a percentage. I know this is probably very basic but I'm not having a good day so be nice to me.
prev ipod shuffle problem
  
next DVD to WMV etc converterter
Gravatar

Answers

1 to 6 of 6rss feed

Best Answer

No best answer has yet been selected by milly143. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image ChuckFickens
divide one by the other and format the cell to be a percentage.
16:08 Wed 09th Feb 2011
Avatar Image ChuckFickens
oppps, ignore me, I miss read the question.
16:11 Wed 09th Feb 2011
Avatar Image ChuckFickens
Right, try again :)

The following will tell you the percentage difference between a1 and b1, again you have to format the cell as a percentage

=(a1-b1)/ABS(b1)
16:15 Wed 09th Feb 2011
Avatar Image milly143
Question Author
That's done it! Thanks Chuck. Any idea on the other sum I need? So it works out the difference as a currency?
16:23 Wed 09th Feb 2011
Avatar Image milly143
Question Author
Oh god I'm so dumb somtimes. How about just A1-B1. Duh!!!!!!
16:28 Wed 09th Feb 2011
Avatar Image ChuckFickens
http://lolpics.se/pics/482.jpg

:-p
16:31 Wed 09th Feb 2011

1 to 6 of 6rss feed

Do you know the answer?

Excel Functions

Answer Question >>