How to max out results of a formula.

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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!
 
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)
 
Perfect-o!!!

Thanx!

When I become a millionaire....
I buying you a Krystal (or White Castle burger)....
And that's With Chesse!
 
You're very welcome...I'm glad I could help.
....and thanks for the generous offer!

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
...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.

---
 
Max said:
Ron,
I'm sulking. OP didn't offer me what he offered you
in 2 of his earlier threads.
Click to expand...

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