China Naming Network - Baby naming - How to design commission table with IF function in EXCEL?

How to design commission table with IF function in EXCEL?

A is listed as performance and B as commission.

= 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))))))

上篇: My son was born on September 27th, 20th12 (August of the lunar calendar12) at 9: 02. His surname is Dong. Please recommend a good name. What about Dong Jianfeng? 下篇: Poems describing auspicious dragons and phoenixes