View Single Post
  #1   Report Post  
T
 
Posts: n/a
Default Continued.....answer 8 - 1.2 = 6.2 from a formula

NT(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 in all cells

Thanks
T