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.

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.

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.

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.