Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue
hi,
I have a -0.02 difference with the following function when it should be 0 =(e57-e62)*5.73 4.73-4.73 *5.73 The only thing that can think be causing this is that e57 is getting its data from a vlookup from another tab which is entered as a fraction 6 2/4. This is picked up as 4.73 as a decimal. I do not want to format the fraction as decimal on the second tab. Is there away around this? Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue
I don't understand how you get 4.73 from 6 2/4, and I think you'll find that
merely formatting the fraction as a decimal will have no effect (unless you take the risky step of using the "Precision as displayed" option). What you may wish to do is use =(ROUND(E57,2)-ROUND(E62,2))*5.73 -- David Biddulph Haz wrote: hi, I have a -0.02 difference with the following function when it should be 0 =(e57-e62)*5.73 4.73-4.73 *5.73 The only thing that can think be causing this is that e57 is getting its data from a vlookup from another tab which is entered as a fraction 6 2/4. This is picked up as 4.73 as a decimal. I do not want to format the fraction as decimal on the second tab. Is there away around this? Any help would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue
hi, thanks for coming back to me.
sorry 4.73 is picking up 4 3/4 and not 6 2/4 as previously stated. how can I add your round function to my vlookup(e49,'tab 2'!. a:l, 6, flase) because when i change the format on the second tab from fraction to number this solves the problem. But i don't want to format the second sheet to decimal. Thanks again "David Biddulph" wrote: I don't understand how you get 4.73 from 6 2/4, and I think you'll find that merely formatting the fraction as a decimal will have no effect (unless you take the risky step of using the "Precision as displayed" option). What you may wish to do is use =(ROUND(E57,2)-ROUND(E62,2))*5.73 -- David Biddulph Haz wrote: hi, I have a -0.02 difference with the following function when it should be 0 =(e57-e62)*5.73 4.73-4.73 *5.73 The only thing that can think be causing this is that e57 is getting its data from a vlookup from another tab which is entered as a fraction 6 2/4. This is picked up as 4.73 as a decimal. I do not want to format the fraction as decimal on the second tab. Is there away around this? Any help would be appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue
thanks don't need to add it to my vlookup your rounding worked.
"David Biddulph" wrote: I don't understand how you get 4.73 from 6 2/4, and I think you'll find that merely formatting the fraction as a decimal will have no effect (unless you take the risky step of using the "Precision as displayed" option). What you may wish to do is use =(ROUND(E57,2)-ROUND(E62,2))*5.73 -- David Biddulph Haz wrote: hi, I have a -0.02 difference with the following function when it should be 0 =(e57-e62)*5.73 4.73-4.73 *5.73 The only thing that can think be causing this is that e57 is getting its data from a vlookup from another tab which is entered as a fraction 6 2/4. This is picked up as 4.73 as a decimal. I do not want to format the fraction as decimal on the second tab. Is there away around this? Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding issue | Excel Discussion (Misc queries) | |||
Rounding issue | Excel Worksheet Functions | |||
Excel Rounding Issue | Excel Discussion (Misc queries) | |||
Rounding issue with Goal Seek for IRR | Excel Worksheet Functions | |||
Another rounding issue | Excel Worksheet Functions |