I need some help figuring out why the % in the last column of a report does not calculate correctly. I have 27 departments that use the same specification file to create departmental reports. There is only one department, where a strange percentage calculates for one of my general ledger accounts.

The formula in the cell is as follows:

=IF(H18==0,0,D18/H18)

There is a 0 in column H18 so why is the result of the formula calculation "2182073184298200100.0%" and only for THAT department and for THAT general ledger account. The answer should be 0.

In this case H18 is "almost" 0

Try

=IF(round(H18,2)= 0,0,D18/H18)

Hello Michael - I knew you would have the answer. This tweak worked like a charm. Thank you so much for your assistance.