excel cell problem

[Sandy]

I'm sure someone will imediately have the answer to this one...but I haven't. I've been trying for ages and am close to throwing the computer out of the office window!!!

I'm on excel...I need some cells to work out 30% of a number and then add it back on...not well put...I'll try again...
I need to increase each figure by 30%...that was clearer.

Before any one thinks I'm a right Charlie, I can easily do it manually...but I need to set this spreadsheet up to do it automatically.

Thanks guys

 

[Gillie]

Sandy

You need to set up a new formula in the cell in which you want the result to appear ie =B3+30%

Sorry Sandy, B3 is just an example of where you want the info to appear, put in your own cell number here.

 

[Sandy]

It might be the operator...but it hasn't worked!!

 

[a-okadmin]

Hi Stefan,

I just tried this =A1/100*30+A1 and it worked. I don't know why but the +30% method didn't work for me either.

 

[Astaroth]

Or even more simple =A1*130%

 

[thejoshm]

or =A1*1.3

 

[Gillie]

Its ok we got there thanks !!

 

[Mike by the Sea]

Has it worked yet Sandy?

 

[Sandy]

Yes
Thanks everyone for your help.

 

[Joyous]

You need to set up a new formula in the cell in which you want the result to appear ie =B3+30%

... I don't know why but the +30% method didn't work for me either.

The +30% method won't work because you have to specify 30% of something. =B3+(30%*B3) would have worked.

Regards

Joy

 

[Gillie]

Yes Joy I realised soon after and rang Sandy and spoke to her direct, we had it sorted within seconds!