# I need to write a formula to us one Ceiling formula if a retail ends in 0-5 and a different Ceiling formula if a retail ends in 6-9.

#### snoopyfan

##### New Member
I have a column of retails and I need to add 0.05 and then round that up to the next amount ending in 5. (Ex: \$2.71 + .05 = \$2.76, rounds to \$2.85.)
I have been trying to use a Ceiling formula like
=Ceiling((AD5+0.05),0.05) but that only works on the retails ending in numbers 6 through 9. Any number ending in 0 through 5 ends up with a "rounded" total ending in 0 instead of a 5
I have to then enter this formula instead in the cells with incorrect results.
I would like to either find one formula that will give me the correct rounded result or can I use an "IF" formula to combine the two above?

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### snoopyfan

##### New Member
Thank you so much Jason, I knew there had to be an easy answer!

Replies
0
Views
22
Replies
0
Views
57
Replies
12
Views
130
Replies
5
Views
138
Replies
6
Views
371