Logic statement returns wrong answer.
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. |
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. |
See
http://www.mcgimpsey.com/excel/pennyoff.html In article , "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. |
All times are GMT +1. The time now is 10:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com