Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round up or down | Excel Discussion (Misc queries) | |||
round down? | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
How can I round UP to to the next ,50? E.g. 2,3 should become 2,5. | Excel Worksheet Functions | |||
How can i round off .10 as .50 and .51 as 1.00 | Excel Worksheet Functions |