It would be easiest to round E10 to a full percentage:

E10: =ROUND(<current formula, 2)

but you could substitute ROUND(E10,2) for any reference to E10 in the
formula I gave you.

In article ,
fivermsg
wrote:

K, that one does work but the only thing is that it add totals on
fractions of %'s.... i only want it to change on full percentages..
could you through and =int, in there somewhere??