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
|
|
|