View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Novice2000 Novice2000 is offline
external usenet poster
 
Posts: 9
Default 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.