maximum in a cell

[Juliana]

Hi, I need help on how to define a maximum in a cell. The
value of cell will be a result of aggregate but not great
than a result of simple formular, for example, D2*50.

Thanks for any help.

Juliana

 

[Frank Kabel]

Hi Juliana
You're looking for MIN
e.g.
=MIN(aggregate_formula,D2*50)

 

[JE McGimpsey]

Does your cell contain a calculation? In that case you can use something
like:

=MIN(SUM(A1:A100),D2*50)

If instead your cell has user entries made in it, choose
Data/Validation/Custom and enter

=A1 < D2*50

in the Formula: textbox (where A1 is your entry cell)

 

[Guest]

Frank,

It works, I am appreciated your help.

Juliana