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

General Forum

can someone help me with an excel formula please?

Neiliboy (Elite) posted this on Friday, 24th June 2005, 11:20

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.......

RE: can someone help me with an excel formula please?

Rich Johnson (Competent) posted this on Friday, 24th June 2005, 11:34

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

RE: can someone help me with an excel formula please?

bigkahunas (Competent) posted this on Friday, 24th June 2005, 11: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

RE: can someone help me with an excel formula please?

Neiliboy (Elite) posted this on Friday, 24th June 2005, 11:44

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.......

RE: can someone help me with an excel formula please?

Rich Johnson (Competent) posted this on Friday, 24th June 2005, 11:49

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.

RE: can someone help me with an excel formula please?

jeffthegun (Elite) posted this on Friday, 24th June 2005, 11:52

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....







What im listening to (if youre interested)

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

RE: can someone help me with an excel formula please?

Rich Johnson (Competent) posted this on Friday, 24th June 2005, 11:57

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

RE: can someone help me with an excel formula please?

Mix Man (Elite) posted this on Friday, 24th June 2005, 12:00

Rich is correct.

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

RE: can someone help me with an excel formula please?

Rich Johnson (Competent) posted this on Friday, 24th June 2005, 12:11

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.

RE: can someone help me with an excel formula please?

Rich Johnson (Competent) posted this on Friday, 24th June 2005, 12:18

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

Go back to General Forum threads, or All Forum threads