max out results of formula...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.W. Aldridge - 29 Oct 2007 20:23 GMT

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?

Reply to this Message

Gord Dibben - 29 Oct 2007 21:06 GMT

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

Gord Dibben MS Excel MVP

>I have the following formula that calculates the weight of a
>performance based on a weight scale.
[quoted text clipped - 6 lines]
>
>How do I get the results to max out at 30 if the goal is met?

Reply to this Message

Bill Kuunders - 29 Oct 2007 21:25 GMT

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

>I have the following formula that calculates the weight of a
> performance based on a weight scale.
[quoted text clipped - 6 lines]
>
> How do I get the results to max out at 30 if the goal is met?

Reply to this Message

Billy Liddel - 30 Oct 2007 00:28 GMT

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

> I have the following formula that calculates the weight of a
> performance based on a weight scale.
[quoted text clipped - 6 lines]
>
> How do I get the results to max out at 30 if the goal is met?

Reply to this Message