Thread: If greater than 5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carolan Carolan is offline
external usenet poster
  
Posts: 24
Default If greater than 5
Need a formula - I know it's simply - just can't get it.
If A1 is greater than 5, then B1 = 5
If A1 is less than 5, B1 should equal the amount in A1
CarolAnn

Reply With QuoteReply With Quote