| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can I get some help here? No response yet :)
=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph text information in Excel | Charts and Charting in Excel | |||
| Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
| Response to Frank: AM-PM Auto formatting | Excel Discussion (Misc queries) | |||
| Counting a range of fields with an "X" | Excel Worksheet Functions | |||
| Help Excel97 gives incorrect multiplication response | Excel Worksheet Functions | |||
Threaded Mode
