Thread: Percentage max formula?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Percentage max formula?
This formula should give you the lesser of the calculated % and 150%:

=MIN(A2/A1,1.5)

Tom

Reply With QuoteReply With Quote