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

I have a cell with a formula but need to have the value produced from that
formula rounded down to the next dollar. Ideas????

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

=FLOOR(A1,1)

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

Regards
Ken.................


"Carol" wrote in message
...
I have a cell with a formula but need to have the value produced from that
formula rounded down to the next dollar. Ideas????

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

rounded down to the next dollar

Try this:

=INT(your_formula_here)

--
Biff
Microsoft Excel MVP


"Carol" wrote in message
...
I have a cell with a formula but need to have the value produced from that
formula rounded down to the next dollar. Ideas????