Page 1 of can someone help me with an excel formula please?

Lets say in column A i have a buying price of £0.50 and column B i have a selling price of £1.00. That equals a 100% increase.

I have two columns full of prices and i want the third column to automatically tell me what the mark up is (or price increase) - I dont know how to a)calculate the fomula and b) put it onto excell cell.

Help please!

Thanks in advance!

Neil
____________________________________
No Humping Stormtroopers here.......

You can format column C as a percentage and then use the following formula in column C:

=(B1/A1)-1 for row 1
=(B2/A2)-1 for row 2

...etc

Hope that helps

Richard

This item was edited on Friday, 24th June 2005, 12:38

Column A = Buying Price
Column B = Selling Price
Column C = Profit ?

If that were the case, then you could type the following directly into Column C, or wherever you want the formula to show

=sum(B2-A2)
B2 and A2 being the cell locations

Let me know if thats what your after, I can try and help you some more if you want.

Whoops, looks like someone else beat me to it - i`d go with theirs because i might be wrong!

This item was edited on Friday, 24th June 2005, 12:41

Hi Rich,

I tried wht you said and the figure comes out as a "0.88" - that tells me i have an 88% mark up on that item which is correct but how do i `format it as a percentage` i.e tell me in a % as opposed to me having to translate from a decimal figure.

Hope this makes sense!

Neil
____________________________________
No Humping Stormtroopers here.......

You should just be able to highlight the cell and click the % button. If you send me your email address I can send you a sample spreadsheet.

If you can`t find the % button, just right click in the cell and choose format cells and on the number tab select percentage.

You can then drag the formula down to save duplication.

the first one was bollocks. I had a bit of a brain fart.

It is actually quite simple, i was just being a dumbass.

you need 4 columns (cells denoted in brackets)

(a1)original price - (b1) selling price - (c1)difference - (d1)percentagemarkup


The column C1 would need a formula of

=B1-A1

Column D1 would need the formula

=(C1/A1)*100

then you just select the corner of the cell marker and drag it down so it autofills the formulas for the rest of the table.

Hallelujah.........

I thought I was going mad for a minute there. I do this kind of crap every day too....

This item was edited on Friday, 24th June 2005, 13:17

Nick - That wouldn`t work out the mark up percent.

Rich is correct.

This item was edited on Friday, 24th June 2005, 13:07

You could do it Nick`s way but you`d still need to include -100 to get the right figure (this way wouldn`t show a percentage sign though).

I`d always stick with my original answer just so it looks nicer in terms of formatting.

Nick - I just liked the original comment about simple maths - made me laugh (not meaning to cause offence).