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

Carol · May 11, 2009

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

Ken Wright · May 11, 2009

=FLOOR(A1,1)

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

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

T. Valko · May 11, 2009

rounded down to the next dollar

Try this:

=INT(your_formula_here)