Excel 2007 : rounding up values to a specific value

[debbelles1]

I am currently compiling a sales spreadsheet for a small business. After calculating the markup from the wholesale price I want to round that value up to either $xx.49 or $xx.99. The criteria is if the value is less than $xx.50 round to $xx.49 If it is greater than $xx.50 then round up to $xx.99. any formula suggestions?!!
Thanks Debelles1

[zbor]

Here, try: =MROUND(A1, 0.5)-0.01

[debbelles1]

Lets say the value is $17.05 and I want that to be rounded to $17.49. and also i have a value of $18. 66 AND THAT NEEDS TO BE ROUNDED TO $18.99.

[zbor]

Sorry, 0,5 missing:

=MROUND(MAX(0.25,A1)-0.25, 0.5)+0.49

Only price 0 will be showed as 0,49. So if you want to avoid this use:

=IF(A1=0,0,MROUND(MAX(0.25,A1)-0.25, 0.5)+0.49)

[debbelles1]

Great thank you so much for your help!