formula for points if less than goal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top