Formula doest work in Excel
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 |
Formula doest work in Excel
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 |
Formula doest work in Excel
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 |
Formula doest work in Excel
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 | | | |
Formula doest work in Excel
< 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 | |
Formula doest work in Excel
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... |
All times are GMT +1. The time now is 05:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com