Thread: how do you change $42.79 to an even number ($42.80)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas Bob Umlas is offline
external usenet poster
  
Posts: 301
Default 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?


Reply With QuoteReply With Quote