Hi Rich, I have a column of $ figures that I am trying to round off example: $235.34 would be $235 and $235.54 would be $235.00 I have added this column across first, now I want to round off the results. I have 40 totals to round off. Thanks Errol Answer from Richard Rost:
Use the INT function. It founds a number down to the nearest integer.
=INT(A1)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
