M
Mayte
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
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