how do I round down a value from a calculation towards zero

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I have a cell with a formula but need to have the value produced from that
formula rounded down to the next dollar. Ideas????
 
=FLOOR(A1,1)

where A1 holds your value, and your value is expressed in dollars.

Regards
Ken.................
 
You must log in or register to reply here.

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

Excel Stop Excel from displaying rounded values 4
Round Down to the nearest multiple 2
ROUNDING DOWN 3
Rounding a Formula Result Up or Down by the 100s 2
Round formula 1
Rounding 4
Rounding time UP to nearest fourth-hour 4
Formula Help 1

Back
Top