=IF((-MAX(0,MIN(H9,100)*0.05)+-MAX(0,(H9-100)*0.02))<-400,-400,IF(H9="","",(-
MAX(0,MIN(H9,100)*0.05)+-MAX(0,(H9-100)*0.02))))

I couldn't make the value any greater than 400 but it could be less than -400
so the cap is at -400

I am sure that it is possible to make it shorter.

edvwvw



M Thompson wrote:
does anyone know how I can put a cap of 400 on this formula?

=IF(H9="","",-MAX(0,MIN(H9,100)*0.05)+-MAX(0,(H9-100)*0.02))

Thanks so much and have...

--
Message posted via http://www.officekb.com