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: 2
Default round up calculations

Hi all,

I am using excel to calculate numbers with percentage increases. I am using
simple calculation formulas that reads the number on the 1st box and then
based on the % that I want to increase the number, gives me the increased
number on the next box. However, the calculation is based on the delimited
number that is on the first box - although I have hide the delimits on the
screen. The question here is how can I make the system calculate the % based
on the rounded number that I can see on the screen and not on the delimited
number which is actualy hidden behind the rounded number?

Thanks a lot for your help.
 
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
Round up or down cybergardener Excel Discussion (Misc queries) 7 April 11th 07 10:10 PM
round down? dbrumit Excel Discussion (Misc queries) 1 February 15th 07 04:35 PM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 10:50 AM
How can I round UP to to the next ,50? E.g. 2,3 should become 2,5. Vincent Excel Worksheet Functions 0 December 29th 04 02:17 PM
How can i round off .10 as .50 and .51 as 1.00 Santosh Budalakoti Excel Worksheet Functions 5 December 21st 04 12:58 PM


All times are GMT +1. The time now is 04:25 AM.

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

About Us

"It's about Microsoft Excel"