IF formula returns wrong result

		Microsoft Office Forums > Microsoft Excel > Excel
IF formula returns wrong result

09-07-2012, 07:03 AM

NBVC

Windows 7 64bit IF formula returns wrong result

Office 2007

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

have a read here to understand what is happening....

http://www.cpearson.com/excel/rounding.htm

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to release hard returns?	markg2	Word	13	05-08-2023 01:38 PM
Convert Formula Result to Static Text	MYGS	Excel	16	01-21-2013 08:18 AM
No tabbing, no returns in forms?	rdowney1	Word	7	06-29-2012 08:35 AM
Can I create a formula that will show result in the same cell and let me copy it down	CranstC	Excel	1	02-11-2012 01:29 AM
IF formula returns TRUE instead of evaluating COUNTIF	ColinC	Excel	4	12-28-2011 08:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.