View Single Post
  #2   Report Post  
George King
 
Posts: n/a
Default

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.