View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!!

It means that W5 is offset 0 columns, the zero can also be left out
The rows are offset with whatever is entered in the named cell Lag__mos
and it also picks up the size of the height from that cell. Meaning that if
Lag_mos = 5
then it will sum W10:W14


--
Regards,

Peo Sjoblom


"HERNAN" wrote in message
...
Hi, I have this formula, I understand everything but after
*sum(offset...etc)
I get lost, does anybody know how to read it, what is that 0 means?
Thank you so much!!!

=IF(Pct_of_FC?=TRUE, of_FC*SUM(OFFSET(W5,Lag__mos,0,Lag__mos)))