anybody knows how to do a formula the will give more points if the actual is
less than the goal but not to exceeed a total of 100 points.

this is what i have so far:

A B C D E
condition weight target actual points
< 15.00 5% 0.72% FORMULA

in points (column E) I have:
=IF((D1=0%),100,(IF(A1="=",D1/(C1)*B1,C1/(D1)*B1)))

I need to have more points if the actual (D) is less than the goal (C) but
don't want to exceed a total of 100 points. Iif 0% is the actual, the outcome
is 100 points but if less than 0% (negative #s), the outcome is zero points.

Cheers,
Mayte