Max Calculation

[Bob]

=G7*E7/C7
The results I have in this formula are correct as long as it does not
go over 25. But I need it to stop changing the calculations once it
goes over 25. Is there a way to Max? Example:
G7 = Lot Charge( from 0 to 25) Do not want this to change if
calculations reaches over 25.
E7 = Total Square Inches
C7 = Qty.
Once my calcuation reaches over 25 do not change previous
calculations.
Thanks in advance!

 

[Gord]

=MIN(G7*E7/C7,25)


Gord Dibben Microsoft Excel MVP

 

[Bob]

=MIN(G7*E7/C7,25)

Gord Dibben     Microsoft Excel MVP



- Show quoted text -

It still changes. Maybe if D3 can be added to formula. D3 is the total
Square feet. Can D3 have a min or max. Thanks for your help.

 

[Gord]

What do you mean by "it still changes".

It certainly won't go over 25 but there is nothing preventing it from
being less than 25 if figures in G7, E7 and C7 are altered.

Any number can have a min or max.

See help on those functions.

Also check out CEILING function.


Gord

 

[joeu2004]

=G7*E7/C7
The results I have in this formula are correct as long
as it does not go over 25. [....]
G7 = Lot Charge( from 0 to 25) Do not want this to change
if calculations reaches over 25.

So "it" is G7, not the entire formula, right Bob? In that case:

=MIN(25,G7)*E7/C7

But then you write:

E7 = Total Square Inches
C7 = Qty.
Once my calcuation reaches over 25 do not change
previous calculations.

What "calculations", Bob? Even if we limit G7 to 25, 25*E7/C7 might exceed
25. Perhaps you want:

=MIN(25,MIN(25,G7)*E7/C7)

One might think it is sufficient to have just the outer MIN(25,...). But it
is not.

If one of these formulas does not work for you, Bob, please give specific
examples G7, E7 and C7 with the required results. Multiple examples are
problem needed in order to demonstrate all the nuances of what you mean by
"calculation reaches over 25".