Am I safe to assume you are using some version of MS-Excel and not some other spreadsheet program?
If so, the explanation of what you want your results to be is confusing. It sounds like you wish Cell #2 to contain a rounded down calculation of cell # 1 to the nearest $99, yet you say $6632 rounded down to a value of $6559 is OK. I would think that $6632 rounded down to the nearest $99 would be $6599. Please clarify.
I also do not see how MS-Excel would accept either formula that you said you tried. The number of closing parentheses does not exactly match the number of opening parentheses. It would also appear that you may be attempting to use a formula in a cell that uses the value in that same cell. As far as I know, that is not permitted in MS-Excel.
I did try one formula based on your original round to the next lowest 99 value requirement. With the pre-rounding value in Cell A1, putting this in cell B1 should do that;
If so, the explanation of what you want your results to be is confusing. It sounds like you wish Cell #2 to contain a rounded down calculation of cell # 1 to the nearest $99, yet you say $6632 rounded down to a value of $6559 is OK. I would think that $6632 rounded down to the nearest $99 would be $6599. Please clarify.
I also do not see how MS-Excel would accept either formula that you said you tried. The number of closing parentheses does not exactly match the number of opening parentheses. It would also appear that you may be attempting to use a formula in a cell that uses the value in that same cell. As far as I know, that is not permitted in MS-Excel.
I did try one formula based on your original round to the next lowest 99 value requirement. With the pre-rounding value in Cell A1, putting this in cell B1 should do that;
Code:
=ROUNDDOWN(A1+1,-2)-1
