LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default roundup function

I want to be able to have an amount in one cell then in aonther cell have the
following function =roundup(c10+15/.9,0) so it takes the amount in the
first cell adds on 15 then divides by .9 (which increases by 10%) and then
round the number. But excel doesn't like this. So i tried to put the
brackets and the rounding just so =roundup(c10+15,0)/.9 which does bring the
correct amount but doesnot round the final amount up. Does anyone know how
or if this can be done?

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Roundup or Ceiling Function to round to a specific number Angie33 Excel Discussion (Misc queries) 26 September 11th 08 04:29 PM
ROUNDUP Function Chacky Excel Discussion (Misc queries) 1 September 5th 07 05:54 PM
Roundup Function brown_toby Excel Worksheet Functions 3 June 30th 06 06:55 PM
can I add a column and roundup with 1 function? Sheila Excel Discussion (Misc queries) 2 March 8th 06 08:33 PM
Roundup Function Will Excel Discussion (Misc queries) 4 February 4th 06 11:41 PM


All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"