J
J.W. Aldridge
I have two formulas that work just fine.
However, I need to max out at value based on the weight.
Example.
D3 = The person's score (10)
E2= Their Goal (10)
D15= That category's weight (in percentage) (35%)
=IF(D3>0,(D3/E$2*(D$15)),"")
Since the person reached the goal, they recieve (results of the
formula is) 35%(d15).
If they exceed goal, this formula currently goes higher than 35%
(d15).
I need to know how to cap it off/max it out at 35% (d15)
2nd Formula, same concept.
Need for this to max out at the value in P15.
=IF(P3="","",IF(P3>K$2,0,(P$15)))
Thanx!
However, I need to max out at value based on the weight.
Example.
D3 = The person's score (10)
E2= Their Goal (10)
D15= That category's weight (in percentage) (35%)
=IF(D3>0,(D3/E$2*(D$15)),"")
Since the person reached the goal, they recieve (results of the
formula is) 35%(d15).
If they exceed goal, this formula currently goes higher than 35%
(d15).
I need to know how to cap it off/max it out at 35% (d15)
2nd Formula, same concept.
Need for this to max out at the value in P15.
=IF(P3="","",IF(P3>K$2,0,(P$15)))
Thanx!