Hi all,

i was applied a simple formula to the first row and when i drag the
same formula down it doest work or the same answer repeats all the
time.

thanks in advance

post the formula

--


Gary


"Abid" wrote in message
oups.com...
Hi all,

i was applied a simple formula to the first row and when i drag the
same formula down it doest work or the same answer repeats all the
time.

thanks in advance

On Feb 20, 11:34 am, "Gary Keramidas" <GKeramidasATmsn.com wrote:
post the formula

--

Gary

"Abid" wrote in message

oups.com...



Hi all,

i was applied a simple formula to the first row and when i drag the
same formula down it doest work or the same answer repeats all the
time.

thanks in advance- Hide quoted text -

- Show quoted text -

there s no Problem with the formula, the problem is applying the
formula to other rows. when i drag and try to apply the same formula
to other cells it shows the same results.
or in other words, let say that in colum "A" we have names and colum
"B" we have their cash in hands in "C" we have thier amounts in the
bank and in colum "D" I want to calculate how much is the total amount
they have in this regard i applied the formula into colum "D" =B1+C1,
becouse there are alot of name and i cant inter formula to each and
want to drag it into the rest to show the answer but it doesnt fill
the exact formula into it.

maybe the there s something in the cell property or what ever,,,,

does anyone know the solution???

plz response

thanks

And check ToolsOptionsCalculation Tab; Calculation should be set to Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message ...
| post the formula
|
| --
|
|
| Gary
|
|
| "Abid" wrote in message
| oups.com...
| Hi all,
|
| i was applied a simple formula to the first row and when i drag the
| same formula down it doest work or the same answer repeats all the
| time.
|
| thanks in advance
|
|
|

< but it doesn't fill the exact formula into it.

So, what *does* it do?
Just not answering questions of those trying to help is not very polite

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Abid" wrote in message ps.com...
| On Feb 20, 11:34 am, "Gary Keramidas" <GKeramidasATmsn.com wrote:
| post the formula
|
| --
|
| Gary
|
| "Abid" wrote in message
|
| oups.com...
|
|
|
| Hi all,
|
| i was applied a simple formula to the first row and when i drag the
| same formula down it doest work or the same answer repeats all the
| time.
|
| thanks in advance- Hide quoted text -
|
| - Show quoted text -
|
| there s no Problem with the formula, the problem is applying the
| formula to other rows. when i drag and try to apply the same formula
| to other cells it shows the same results.
| or in other words, let say that in colum "A" we have names and colum
| "B" we have their cash in hands in "C" we have thier amounts in the
| bank and in colum "D" I want to calculate how much is the total amount
| they have in this regard i applied the formula into colum "D" =B1+C1,
| becouse there are alot of name and i cant inter formula to each and
| want to drag it into the rest to show the answer but it doesnt fill
| the exact formula into it.
|
| maybe the there s something in the cell property or what ever,,,,
|
| does anyone know the solution???
|
| plz response
|
| thanks
|

Abid wrote:
Hi all,

i was applied a simple formula to the first row and when i drag the
same formula down it doest work or the same answer repeats all the
time.

thanks in advance

Hi,

Do you find "$" signs in the original formula? If so then remove the "$"
signs and then drag the formula down. Should work...