| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
trouble with subtracting cells and adding text...
A1=4278.39
Q12=4318.00 MY FORMULA IS... =(Q12-A1)&"HRS" IAM GETTING ... 39.6099999999997HRS WHEN I SHOULD GET... 39.61HRS IT ONLY HAPPENS WHEN I PUT THE... &"HRS" AT THE END OF THE FORMULA... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trouble with subtracting cells and adding text... | Excel Discussion (Misc queries) | |||
| Adding up cells that include text in them | Excel Discussion (Misc queries) | |||
| adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
| Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) | |||
| Adding two text cells together | Excel Discussion (Misc queries) | |||
Threaded Mode
