Assume the value 20 is in A1, try this in B1:

=MIN(A1,80)

Hope this helps.

Pete

Truc Lopez wrote:

I want to create a formula to look at a value in a cell to see if it is
greater or less than a specified number. If the cell is less than the
specified number then I want to use that number. If the cell is greater than
the specified number then I want to use the specified number.

Example:

20 ---- If cell is < 80, then 20; if cell is or= 80, then 80

Thank you in advance for your help.