Say you're looking at the value in A1.<20

Say the "specified" number is in B1.<80

=MIN(A1,B1)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Truc Lopez" wrote in message
...
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.