=INT(INT(A1)+MOD(A1,1)*2.5+INT(B1)+MOD(B1,1)*2.5-(INT(C1)+MOD(C1,1)*2.5))+(MOD(INT(A1)+MOD(A1,1)*2. 5+INT(B1)+MOD(B1,1)*2.5-(INT(C1)+MOD(C1,1)*2.5),1)*0.4)

I need this to have one more column -- and have the whole formula to be able
to read negative numbers as well in all cells

Thanks
T

Was this post helpful to you?


Reply | Print post TopTop