1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!!
 

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

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

1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!!
 

OFFSET(W5,Lag__mos,0,Lag__mos)

W5 is the cell from which the offset is calculated.

Las_mos id a named range and the first occurence specifies the number of
rows down from W5 that offset is i.e the first cell to SUM: if lag_mos=5,
then offset cell is W10. The second occurence is the number of cells to sum,
so our example it is 5:

So the summation is equivalent to SUM(W10:W14)

HTH

"HERNAN" wrote:

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