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.

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.

Pete, thank you for your response. However, the formula did not work for me.
I went to the end cell and typed in the formula you provided and substituted
in the actual cell number in place of A1 and what I got was the formula
rather than a number. What did I do wrong?

"Pete_UK" wrote:

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.

Your cell was probably formatted to Text.

Format the cell to General or Number, then click in the formula bar and hit
<Enter to register the change.
--

HTH,

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

"Truc Lopez" wrote in message
...
Pete, thank you for your response. However, the formula did not work for
me.
I went to the end cell and typed in the formula you provided and
substituted
in the actual cell number in place of A1 and what I got was the formula
rather than a number. What did I do wrong?

"Pete_UK" wrote:

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.

Perhaps that cell had been pre-formatted as text. Select the cell again
and Format | Cells | Number (tab) | General | OK, then double-click the
formula as if to edit it and then press <Enter.

Alternatively, your worksheet might be set to manual calculation -
press F9 to recalculate the sheet.

Hope this helps.

Pete

Truc Lopez wrote:

Pete, thank you for your response. However, the formula did not work for me.
I went to the end cell and typed in the formula you provided and substituted
in the actual cell number in place of A1 and what I got was the formula
rather than a number. What did I do wrong?

"Pete_UK" wrote:

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.

This should do ya
=IF(A1<80,20,80)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"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.

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.