Thread: why does when i drag a formula in excel gives the same value?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default why does when i drag a formula in excel gives the same value?
Hi,

You may have absoluted the reference in your formula by using the $ sign.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"oliver" wrote in message
...
in excel, when i drag the formula it gives the same value with the
reference
eventhough the succeding numbers are deferent.

Reply With QuoteReply With Quote