Wednesday, February 27, 2013

yogi_Compute Exactness Of Amount Computed (column C) And Amount Actually Written Out (column D)

                                          Google Spreadsheet   Post  #1052
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Feb 27, 2013
user rajvivek said:(!searchin/docs/rajvivek/docs/_RY-7Hw3120/HEBtK1CT4XQJ)
EXACT formua is not working expectadly in few of the cells...

I am trying to use a simple formula : =ARRAYFORMULA(EXACT(C3:C7, D3:D7)) but it seems to be not giving the expected result at few of the cells.

Please see this sheet. The cell E4 should be telling TRUE instead of FALSE. Please tell me both : WHY it is not giving the desired result, and HOW to fix it.



the discrepancy is because of floating point arithmetic ... the numeric part of the entry in cell D8 is actually 17 characters long in contrast to 4748.1 apparently 6 characters long that it appears to be... so the following proposed solution