Using rounded numbers for display, but not for the calculation.

  • Thread starter Thread starter MKode
  • Start date Start date
M

MKode

Hello,

I am dealing with a workbook that calculates numbers in millions. I
would like to display calculated amounts rounded to the nearest
thousand. However, I would like to perform my calculations on the
numbers rounded to a nearest dollar. What would be the solution for
this? Is there a special formatting feature?

Thanks!!!
 
In the cells round the value top the dollar

=ROUND(amt,0)

but format the cells as #,##0,

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding down to nearest 1/32 3
Round time to nearest 15 minutes in decimal format 4
Formula Help 1
Rounding to the nearest cent...currency values 3
round up to nearest 50p 1
rounding up to nearest specified whole number 1
how to multiply two values and round the result 5
Excel Stop Excel from displaying rounded values 4

Back
Top