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

T

T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can I get some help here? No response yet :) 5
Convert inches & display as Feet Inches and Fractions -- BUG FREE 12
I wonder if you can make this shorter 0
Using the LEFT formula for multiple cells 2
Using the AND and OR functions in the same formula 6
Workdays 1
Adding Columns with Multipliers 4
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1

Top