Discussion a*b≠a*b error in excel in Excel
https://techcommunity.microsoft.com/t5/excel/a-b-a-b-error-in-excel/m-p/1841156#M79629
<P>Hello,</P><P>I'm currently working in a very large excel spreadsheet that contains many tiny numbers. As you can see in the picture (I'm using an if statement which is 1 if they are equal and 0 if not) it says that AHP31=AHO31 and AHP32=AHO32 but apparently AHO31*AHO32=AHP31*AHP32 is false. The difference is around 1.3*10^-28. I haven't formatted any cells manually so this is very confusing.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 315px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/230635iEAB57A4892E1EB20/image-size/large?v=1.0&px=999" role="button" title="image.png" alt="image.png" /></span></P><P> </P>Sat, 31 Oct 2020 15:27:05 GMTBanu13372020-10-31T15:27:05Za*b≠a*b error in excel
https://techcommunity.microsoft.com/t5/excel/a-b-a-b-error-in-excel/m-p/1841156#M79629
<P>Hello,</P><P>I'm currently working in a very large excel spreadsheet that contains many tiny numbers. As you can see in the picture (I'm using an if statement which is 1 if they are equal and 0 if not) it says that AHP31=AHO31 and AHP32=AHO32 but apparently AHO31*AHO32=AHP31*AHP32 is false. The difference is around 1.3*10^-28. I haven't formatted any cells manually so this is very confusing.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 315px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/230635iEAB57A4892E1EB20/image-size/large?v=1.0&px=999" role="button" title="image.png" alt="image.png" /></span></P><P> </P>Sat, 31 Oct 2020 15:27:05 GMThttps://techcommunity.microsoft.com/t5/excel/a-b-a-b-error-in-excel/m-p/1841156#M79629Banu13372020-10-31T15:27:05ZRe: a*b≠a*b error in excel
https://techcommunity.microsoft.com/t5/excel/a-b-a-b-error-in-excel/m-p/1841207#M79631
<P><LI-USER uid="852899"></LI-USER> </P>
<P>Excel's uses IEEE 754 - see <A href="https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result" target="_blank" rel="noopener">Floating-point arithmetic may give inaccurate results in Excel</A> </P>
<P> </P>
<P>In short, you cannot expect results to be exactly correct, so you should round the result of formulas.</P>Sat, 31 Oct 2020 16:24:11 GMThttps://techcommunity.microsoft.com/t5/excel/a-b-a-b-error-in-excel/m-p/1841207#M79631Hans Vogelaar2020-10-31T16:24:11Z