=IF(C4>1000,$B$9*7.23,IF(C4>500,$B$9*7.54,IF(C4>300,$B$9*7.86,IF( AND ( C4>100, C4 <> 150 ) ,$B$9*8.3, IF ( C4 = 150 , calc for 150 , $B$9*9.2)))))