Rounding issue

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

 

[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

 

[Haz]

thanks don't need to add it to my vlookup your rounding worked.