maximum in a cell

  • Thread starter Thread starter Juliana
  • Start date Start date
J

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
 
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)
 
Back
Top