View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
georana georana is offline
external usenet poster
 
Posts: 2
Default 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.