Remember Me?

#1
December 2nd 04, 04:05 AM
 Tony Posts: n/a
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.

#2
December 2nd 04, 04:55 AM
 George King Posts: n/a

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
December 2nd 04, 06:07 AM
 JE McGimpsey Posts: n/a

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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Wayne Excel Discussion (Misc queries) 2 December 22nd 04 08:46 PM Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM

All times are GMT +1. The time now is 02:16 PM.