max out results of formula...

[J.W. Aldridge]

I have the following formula that calculates the weight of a
performance based on a weight scale.

H2=GOAL
G3 = PERFORMANCE
G25 = WEIGHT (30 POINTS)


=(H$2/(G3))*G$25



How do I get the results to max out at 30 if the goal is met?

 

[Gord Dibben]

=MIN(30,(H$2/(G3))*G$25)


Gord Dibben MS Excel MVP

 

[Bill Kuunders]

I assume that normally the goal is larger than the performance.
I.e. your base formula should be G$25*G3/H$2
weight * performance / goal

To max it at 30
=if(G$25*G3/H$2>=30,30,G$25*G3/H$2)

Greetings from New Zealand

 

[Guest]

You might also like to look at Goal Seek in the Tools Menu - this will change
one the criterion that you select to meet the target (30)

Regards
Peter