Please Help With < and
 

I am trying to write an expression that takes an amount in a separate column
and if it is less than or equal to $100 shows $100. If it is greater than
$100 then show the original amount.

So, if the amount is $500 then $500, but if the amount is $56 then $100.

Please Help With < and
 

=MAX(A1,100)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Novice2000" wrote in message ...
|I am trying to write an expression that takes an amount in a separate column
| and if it is less than or equal to $100 shows $100. If it is greater than
| $100 then show the original amount.
|
| So, if the amount is $500 then $500, but if the amount is $56 then $100.
|

Please Help With < and
 

Perfect. Thank you so much.

"Niek Otten" wrote:

=MAX(A1,100)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Novice2000" wrote in message ...
|I am trying to write an expression that takes an amount in a separate column
| and if it is less than or equal to $100 shows $100. If it is greater than
| $100 then show the original amount.
|
| So, if the amount is $500 then $500, but if the amount is $56 then $100.
|