Logic statement returns wrong answer.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical test in IF statement returning incorrect result 3
Rounding Formula 3
Formula help 3
Access stripping decimal places in query 1
Determine decimal 5
Addition errors with Decimal Places 5
the decimals extends after the sum function 2
Excell 2007 Pivot Table Calculation changes decimal places 2

Back
Top