round up calculations
Thanks a lot Niek. That is exactly what I was looking for.
Thanks again.
George
"Niek Otten" wrote:
Read in help about ToolsOptionCalculation tab, Precision as displayed
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"georana" wrote in message ...
| 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.
|