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.