ProperCharlie

this is probably pretty obvious but i am having a brain ache. can someone tell me what to do please - what i want is to have last year's salary in one column, this year proposed salary in the next column, and a third column that will autmotically caculate the % increase in salary. this is in excel btw.

so what formula do i need in the third column?

tia

fast bloke

=(B1-A1)/B1*100 assuming A1 is first number and B1 is increase

HankScorpio

probably a more elegant way to do it but how about:
=((B1-A1)/A1)*100

fast bloke

oops - Hank is correct -

HankScorpio

fast bloke lives up to the name, but only just...

fast bloke

with a typo - I was using a formula for margin instead of markup someone wouldn't be to impressed at the end of the year

HankScorpio

wow, that's twice!
Re-reading, I didn't mean yours was inelegant, my sentence should have began:
"There is..."

I wasn't aware of your response at the time of typing, I was too busy recalling BODMAS as Mr Cowie explained to us many years ago..!!

ProperCharlie

cheers - through trial and error i eventually came up with ((A1/B1)-1)*100 which seemed to work, but i think i'll change it to hank's suggestion.

ChrisB

I was sat there thinking of BODMAS as taught by Mr Gooding (very Welsh) at college

beemerboy

edited coz i didnt refresh page and there was more answers then i could poke a stick at.

BB

HankScorpio

ChrisB, I'll put money on the fact that he probably wore Farrah slacks...?

ProperCharlie

ah - long time no see you in here, munich motor lad.

still busy installing restaurants?

fast bloke

BODMAS? - Was I not paying attention that day

HankScorpio

Brackets
Or
Divide
Multiply
Add
Subtract

the other one i *might* remember is SohCahToa
Couldn't do anything with it but funny how you rember these things.

Oooh, and Roy G. Biv...

ProperCharlie

doesn't it stand for:

Sine
Opposite
Hypotenuse
Cosine
Adjacent
Hypotenuse
Tan
Opposite
Adjacent

?

**** knows what it means though.

Geddon

Trig in right angle triangles- used to love that

ProperCharlie

well i knew it was about triangles....

farmer1

SOHCAHTOA:

Sine(Theta)=Opposite/Hypotenuse

Cosine(Theta)=Adjacent/Hypoyenuse

Tan(Theta)=Opposie/Adjacent

Where as I use BIDMAS rather then BODMAS
Brackets
Indicies
Division
Multiplication
Addition
Subtraction

speedking

Some
Officers
Have
Curly
Auburn
Hair
Till
Old
Age

Probably easier to remember the original than the mnemonic

HankScorpio

not convinced speedking, we were told it was the chinese for trigonometry, and 20 odd years later, having never used it, it seems to have stuck!