Complex formula

  • Thread starter Thread starter Stefanie
  • Start date Start date
S

Stefanie

If a cell contains a currency rate $13.02 I want to round
it to the nearest .00. But if the cell is $13.04 I want
to round it to .05.
If the rate is .01, .02, 0.8, .09 it should be rounded
to .00
If the rate is .03, .04, .06, .07 it should be rounded
to .05

HELP!
 
Back
Top