how do you change $42.79 to an even number ($42.80)
 

My program has to calculate a percentage recoverable and then this amount is
deducted from a maximum of 3 figures. My problem is that if the percentage
is an odd number, I will end up being out .01. What do I do to avoid this
problem?

how do you change $42.79 to an even number ($42.80)
 

=EVEN(A1*100)/100
Bob Umlas
Excel MVP

"Jean9" wrote in message
...
My program has to calculate a percentage recoverable and then this amount
is
deducted from a maximum of 3 figures. My problem is that if the
percentage
is an odd number, I will end up being out .01. What do I do to avoid this
problem?

how do you change $42.79 to an even number ($42.80)
 

Try this.

A1 = some number like 42.79

=ROUND(A1/0.02,0)*0.02

--
Biff
Microsoft Excel MVP


"Jean9" wrote in message
...
My program has to calculate a percentage recoverable and then this amount
is
deducted from a maximum of 3 figures. My problem is that if the
percentage
is an odd number, I will end up being out .01. What do I do to avoid this
problem?

how do you change $42.79 to an even number ($42.80)
 

=ROUND(A1,1)

Format to 2 DP


Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 09:50:01 -0700, Jean9
wrote:

My program has to calculate a percentage recoverable and then this amount is
deducted from a maximum of 3 figures. My problem is that if the percentage
is an odd number, I will end up being out .01. What do I do to avoid this
problem?