What logic statement?
You can Round() the answer to end up with however many decimals you want.
Round(otherFormula,2) will result in 2 decimals.
Round(otherFormula,-2) rounds to nearest 100
"Tony" wrote:
I have a spreadsheet with decimals at 2 places, but certain numbers result in
amounts greater than 2 decimal places resulting in a wrong answer to the
logic statement. The numbers are not rounded, but input directly.
|