Rounding Selling Prices

[The Animal]

Hi.
I have a worksheet that is used for calculating selling prices over multiple price levels for a daily changing cost price.
I need the formula to round UP to 0.05 i.e 2.22 to $2.25 etc the current formula is =$AH11*M11 and round UP $0.10 i.e 14.02 to 14.10 etc for another with formula =$AG11*F11

Any help appreciated

Thanks

 

[T. Valko]

Hi.
I have a worksheet that is used for calculating selling prices over multiple price levels for a daily changing cost price.
I need the formula to round UP to 0.05 i.e 2.22 to $2.25 etc the current formula is =$AH11*M11 and round UP $0.10 i.e 14.02 to 14.10 etc for another with formula =$AG11*F11

Any help appreciated

Thanks

To round up to the next 0.05...

=CEILING(number,0.05)

To round up to the next 0.10...

=CEILING(number,0.1)

 

[The Animal]

Thanks for reply
Sorry to be stupid so how would my formula examples look?
Stephen

 

[T. Valko]

Thanks for reply
Sorry to be stupid so how would my formula examples look?
Stephen

Like this...

=CEILING($AH11*M11,0.05)

=CEILING($AG11*F11,0.1)