1. Hi,

Is there any way that I can get this formula to work, taking partial pennies into account? see attached......

=IF((SUM(D5,H5,L5,P5,T5,X5)=AB5),""Balanced"",""Er ror"")

[attachment=83321:Error.xls]

2. Thinking something like

=IF((SUM(D5,H5,L5,P5,T5,X5)-AB5<>0.0099999999),"Error","Balanced")

But still reports error. ??

3. Hello VegasNath:
You can try with "Screen precision" inside to options...

4. You could also use the Round function

=IF((SUM(Round(D5,2),Round(H5,2),Round(L5,2),Round (P5,2),Round(T5,2),Round(X5,2)
)-Round(AB5,2)<>0),"Error","Balanced")

Round uses the figure in the cell rounded to 2 Decimal Places in this case so should eliminate those small rounding errors.

Round(SUM(whatever),2)-Round(AB5,2) might work as well

=IF(ROUND(SUM(D5,H5,L5,P5,T5,X5)-AB5,2)=0,"Balanced","Error")

Change the 2 to how many decimal points are important to you. This will balance if the difference is <0.005. Increasing the 2 to 3,4,5, changes the number of zeroes to <0.0005, <0.00005, 0.000005, etc

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•