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