$3.$ Nested IF $+$ Absolute Ref $($in one formula$)(4$ points$)$Delete the shapes I used to explain the problem before solving.Given the sales amounts & commission rates, calculate commission $s$,$ using ONE formula that will be copied to the whole columns C and E$.$

RepQ$2$Q$2$ CommissionQ$3$Q$3$ Commission$$Hints and tips:A whole bunch of Ifs

NameSales $($$$)($$$)$Sales $($$$)($$$)$Commission RatesWe know that: commission$ $=$ Sale$ $*$ rate$\%$Adam$1200900$Threshold $($$$)$Rate$\%$And here, the rate$\%$ is not a fixed one:Ben$29949900$it depends on the sale$$,$ in a step schedule.Candy$3505003001\mathrm{.}50\%$So$,$ in the multiplication, the rate needs to be determined in IFs.Denise$100019995002\%$So it's like: repeating the same logic$$Edward$29950010002\mathrm{.}20\%$Sale$ $*($IF more than certain $$$$$,$ Rate$\%,$ otherwise IF$...)$Frank$30049920002\mathrm{.}50\%$with the Threshold$ and Rate$\%$ go down the schdule$$Grace$400499$If a sales amount reaches $($i$.$e$.,>=)$ the threshold on column F$,$ the rep will be entitled to the corresponding rate in G$($columns F and G$).$ Here you have nested IFs.Hank$16002000($Note: The logic to determine commission$\%$ is similar to that of determining grades $$ A$-$B$-$C$-$D$-$F$)$