Excel spreadsheet formula

bigfoot125

i need the following formula to put in my sheet,it goes along the lines of

15 divided by 268 times 100

i need this to be replicated in one column all the way down afterwards

can you assist me for my excel spreadsheet

thanks

Lokolo

=(15/268)*100

Then click on the bottom right of the cell where theres a small black square, and drag it down.

simon.griggs

Dear Bigfoot125,

You should insert the formula =((15/268)*100) in the first cell. Then highlight that cell and click the edit menu followed by copy.

Next, highlight the second cell and holding down the shift key the last cell you want to paste the value into and then click the edit menu followed by paste.

That should do it.

I hope this helps

Regards


Simon.

calvinac

=(15/268)*100 - this formula should be given on top of the sheet.

weegie.geek

The way you've written it, it could be:

( 15 / 268 ) * 100 = 5.597

or

15 / ( 268 * 100 ) = 0.0005597

Big difference, you need to work out what way it needs done first.

LittleVoice

bigfoot125 wrote: »

i need the following formula to put in my sheet,it goes along the lines of

15 divided by 268 times 100

i need this to be replicated in one column all the way down afterwards

can you assist me for my excel spreadsheet

thanks

May I ask why you want to put that same formula in each cell of a column? Will any of those figures change?

There are other ways you could deal with it which could make changes easier to do in the future. But perhaps you can learn about those later if you are really only just starting to use spreadsheets.

calvinac

weegie.geek wrote: »

The way you've written it, it could be:

( 15 / 268 ) * 100 = 5.597

or

15 / ( 268 * 100 ) = 0.0005597

Big difference, you need to work out what way it needs done first.

yes and other way is 15 / (268 * 100) = 5.5970

PasturesNew

Perhaps the OP can explain what they're trying to do as the method seems peculiar and isn't using Excel to its strengths.

Mobeer

The easier way mentioned by other posters:

(i) Have the formula just once in for example cell C1
Then cell C2, C3 etc have the same formula "=C$1$"
This way, to update the values in the calculation you only need edit cell C1.

(ii) Put the formula into a separate sheet, or separate part of the same sheet
Then name the cell (eg Insert>Name>Define in Excel 2000)
Where the result of the calculation is needed, refer to the cell by name
"=B1*name_i_defined"

Zazen999

Or just calculate it and put the result in the cell...or the column will have different figures to calculate percentages [hence the *100]....if the OP could come back and tell us what they are actually trying to do it would help.

Lil306

Mobeer wrote: »

The easier way mentioned by other posters:

(i) Have the formula just once in for example cell C1
Then cell C2, C3 etc have the same formula "=C$1$"
This way, to update the values in the calculation you only need edit cell C1.

(ii) Put the formula into a separate sheet, or separate part of the same sheet
Then name the cell (eg Insert>Name>Define in Excel 2000)
Where the result of the calculation is needed, refer to the cell by name
"=B1*name_i_defined"

Mobeer has given the best solution, in first part

Putting in the formula then giving it the absolute reference link, that way you only ever have to touch one formula.:money: