= IF(A2 & lt;; = 40,a2 * 0.2, IF(A2 & lt;; = 100, A2*0.3, IF(A2 & lt;; = 300,a2 * 0.4, IF(A2 & lt;; = 500,a2 * 0.45, IF(A2 & lt;; = 1000, A2*0.5, IF(A2 & gt;; 1000, a2 * 0.55,0)))))