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
|