| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. | |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
