ExcelBanter - Continued.....answer 8 - 1.2 = 6.2 from a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Continued.....answer 8 - 1.2 = 6.2 from a formula (https://www.excelbanter.com/excel-worksheet-functions/8224-continued-answer-8-1-2-%3D-6-2-formula.html)

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

All times are GMT +1. The time now is 01:32 PM.