Thread: combining MIN and MAX formulas...
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default combining MIN and MAX formulas...
Hi,

Am Fri, 24 Jun 2016 16:55:59 +0100 schrieb DUV:

=IF(AND(A1*0.15%<=350),350,IF(AND(A1*0.15%350,A1* 0.15%<1500),A1*0.15%,IF(AND(A1*0.15%=1500),1500)) )

try:
=MAX(MIN(A1*0.15%,1500),350)


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote