Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: using formula to generate values

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
using formula to generate values
I have a formula which is as follows: Code: --------- =12*NETWORKDAYS(B1,D1)-12+IF(NETWORKDAYS(D1,D1),MEDIAN(MOD(D1,1)*24,6,18),18)-MEDIAN(NETWORKDAYS(B1,B1)*MOD(B1,1)*24,6,18) --------- I want to copy this formula down my sheet until the last value in the D or B column however this makes...