Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |