Need help with formulas for a spreadsheet based on price comparison

**jdmeadows** · 08-16-2009, 06:59 AM

Hey guys,

Would really appreciate some basic formula advice. I am doing a project and the data looks like this:

Shop A Shop B Shop C Shop D
Product 1 5 5 5.25 4.95
Product 2 21 21.22 20.99 25.30
Product 3
Product 4
Product 5

etc and its a v long spreadsheet.
I need formulas to work out:
1) On how many products Shop A is beaten on price
2) Which Shop is beating it the most
3) On average is Shop A cheaper than the rest?
4) When Shop A is cheaper, how much cheaper is it than the next lowest.

I would appreciate help so much!

Thank you

JD

**martindwilson** · 08-16-2009, 07:10 AM

a project for who?
what have you come uo with so far?

**zbor** · 08-16-2009, 07:34 AM

Can you upload example?

**martindwilson** · 08-16-2009, 07:40 AM

just that projects sound suspiciously like course work!

**mudraker** · 08-16-2009, 08:02 AM

jdmeadows

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

**jdmeadows** · 08-16-2009, 11:11 AM

It is a project for my company - I suppose I had exaggerated my Excel knowledge.

So far I have managed to do the first bit. i.e. I have used an IF formula to work out how many times the first shop is beaten on price.

I'm struggling to find a way to find out by how much cheaper it is when it is cheaper.

Will upload as soon as I get home.