On 2002-06-03 14:43, patshan wrote:
What a great site. I am an advanced beginner and I am having trouble taking the results of a formula and rounding the number down to the nearest hundred. For instance, 1,333 would be rounded down to 1,300 and 526 would be rounded to 500. I use the paste function but keep getting the circular reference. Any help would be greatly appreciated to this self taught user.
Steve
PS
=$L$103/A12 This is a copy of the formula in question. As I said, I am an advanced beginner. Sorry for the tagging onto the original question, however I do not see a post button.