ExcelBanter - Can I increase a number by 5.5% and then round that number to the.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I increase a number by 5.5% and then round that number to the. (https://www.excelbanter.com/excel-discussion-misc-queries/96573-can-i-increase-number-5-5%25-then-round-number.html)

Jeff Thornburg

Can I increase a number by 5.5% and then round that number to the.

I am trying to increase a price by 5.5% and then take the new number to the
next interval of 5's. Is this possible to do in one formula?

Bearacade

Can I increase a number by 5.5% and then round that number to the.

=ceiling((a1*1.055),5)

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556550

All times are GMT +1. The time now is 02:18 PM.