=IF(AND(D11="Salon Head",D42>="105.01%"),"12000",IF(AND(D11="Salon Head",D42>="100.01%"),"7200",IF(AND(D11="Salon Head",D42>="95.01%"),"5400",IF(AND(D11="Salon Head",D42>="90.01%"),"4800",IF(AND(D11="Salon Head",D42>="85.01%"),"4200",IF(AND(D11="Salon Head",D42<"85%"),"0"))))))
Bookmarks