Thread
:
trouble with subtracting cells and adding text...
View Single Post
#
1
traybuddy
Posts: n/a
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...
Reply With Quote