| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
| How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
| display the answer for a formula from another page? | New Users to Excel | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
