How to max out results of a formula.

[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!

 

[Ron Coderre]

Try this:

=IF(D3>0,MIN(D3/E$2*D$15,D$15),"")

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[J.W. Aldridge]

Perfect-o!!!

Thanx!

When I become a millionaire....
I buying you a Krystal (or White Castle burger)....
And that's With Chesse!

 

[Ron Coderre]

You're very welcome...I'm glad I could help.
....and thanks for the generous offer!

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Max]

...and thanks for the generous offer!
Ron,
I'm sulking. OP didn't offer me what he offered you
in 2 of his earlier threads.

---

 

[Bob I]

Ron,
I'm sulking. OP didn't offer me what he offered you
in 2 of his earlier threads.

I've had White Castle, ONCE. I was thinking he didn't like the answer,
was why the offer.

 

[Max]

I was just bantering with Ron, Bob.
Think the OP was sincere in his thanks.

---