Logic statement returns wrong answer.

T

Tony

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.
 
G

George King

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
 

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

Excel does not accept text format! 0
Page numbering with Merged Document and IF statements 1
Mail Merge - displaying a conditional number of decimals 5
Logical test in IF statement returning incorrect result 3
Getting text or numerical data from the formula 2
Incone & Expenses Statement 0
Determine decimal 5
Help with calculating tax percentages 2

Top