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.