| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
