Bulk price Increase

[Faulkds]

Mike, I am a complete idot when it comes to excel.

How do i do it so it rounds to 95 but not necessary back to 95.

What i mean is if a price is 7.35 it will go to 6.95

I want it so it goes to 7.95

[Mike Hughes]

Don't worry. It's just a question of rounding up. The question is where do you want the cut off point. i.e. do want everything rounding up to the next .95 or only things above a certain level ? for example you might want 6.99 to round down to 6.95 but everything over 7.00 to round up to 7.95. It's easy enough to code, you just have to define what you want.

Mike

[Faulkds]

Hi Mike,

I want everything to round up to the next .95p

[Mike Hughes]

This should do it.

=ROUNDUP(Ax+5,-2)-5

everything over 95p will round up to the next 95p. Ax is the location of the number to be rounded up.

Mike

[Faulkds]

Mike,

Thanks alot for your help, it worked.

I've imported the spreadsheet back into Access and now hoping for the best ;-)

Much appreciated, I will have to get "Excel for Dummies"