Rounding issue

H

Haz

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.
 
D

David Biddulph

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
 
H

Haz

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
 
Top