Trying to create a formula that can round number up to a certain value depnding on the #

Hi All!

I haven't been having luck-- I am trying to get a formula that sees to the following:

If the price in A2 is <$3, then the cell in B2 should round the decimal points (cents) up or down (the nearest number) of these 3: .39, .69, .99
If the price in A2 is >$3 but <$10, then the cell in B2 should round the decimal points (cents) up or down (the nearest number)of these 2: .69, .99
If the price in A2 is >$10, then the cell in B2 should round the decimal points (cents) up or down (the nearest number) to .99

Help!

It's a bit of a monster, but try this in B2:

=IF(A2<=3,IF(AND(MOD(A2,1)>0.2,MOD(A2,1)<=0.55),ROUNDUP(A2,0)-0.61,IF(AND(MOD(A2,1)>0.55,MOD(A2,1)<=0.85),ROUNDUP(A2,0)-0.31,ROUND(A2,0)-0.01)),IF(A2<10,IF(AND(MOD(A2,1)>0.35,MOD(A2,1)<0.85),ROUNDUP(A2,0)-0.31,ROUND(A2,0)-0.01),ROUND(A2,0)-0.01))

then copy down as required.

Hope this helps.

Pete

Thanks everyone! Pet_UK's solution was the closest, but still no cigar. This is what happened(the formula was in the second column):

2.25 1.99
2.12 1.99
2.06 2.99
2.88 2.39
2.48 -0.01
12.55 1.99
20.32 1.99
9.06 2.99
9.52 2.39


This is what i was hoping to happen:

2.25 2.39
2.12 1.99
2.06 1.99
2.88 2.99
2.48 2.39
12.55 12.99
20.32 19.99
9.06 8.99
9.52 9.69

Thank you! This works perfectly!

I put your numbers in column A starting at A2 and put my formula in B2 and copied it down - it produces exactly the same values that you were hoping for (file attached), so you mustn't have copied the formula properly.

Hope this helps.

Pete