| 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... |
|
#2
|
|||
|
|||
|
If you always have 2 decimal places, there should be no harm if you use the ROUND function. -- Faz ------------------------------------------------------------------------ Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830 View this thread: http://www.excelforum.com/showthread...hreadid=476090 |
|
#3
|
|||
|
|||
|
Hi
I think you will need to use =TEXT((Q12-A1),"0.00")&" HRS" Regards Roger Govier traybuddy wrote: 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... |
|
#4
|
|||
|
|||
|
I agree with Roger except I think you need a /100 in the calculation.
Even if you put in 0.00000000% you still retain the integrity of the calculation. I tried several options including Concatenate and all but this method lose the accuracy of the calculation. Anyone know why? -- Cricketer "traybuddy" wrote: 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... |
|
#5
|
|||
|
|||
|
Use:
=text(Q12-A1,"0.00")&" HRS" Mangesh "Cricketer" wrote in message ... I agree with Roger except I think you need a /100 in the calculation. Even if you put in 0.00000000% you still retain the integrity of the calculation. I tried several options including Concatenate and all but this method lose the accuracy of the calculation. Anyone know why? -- Cricketer "traybuddy" wrote: 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... |
|
#6
|
|||
|
|||
|
Hi
A better alternative than my first posting would be to format the cell. FormatCellsNumberCustom and in the white pane type #,##.00 "HOURS" You will then see 39.61 HOURS but the numeric value will still be 39.6099999999997 Regards Roger Govier Cricketer wrote: I agree with Roger except I think you need a /100 in the calculation. Even if you put in 0.00000000% you still retain the integrity of the calculation. I tried several options including Concatenate and all but this method lose the accuracy of the calculation. Anyone know why? |
| Reply |
| 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) | |||
Linear Mode
