Using multiple IF statements in Excel. Learn | Five Minute Lessons

Learn how to use multiple IF statements to calculate sales commission for a range of different sales figures and commission percentages. ... I'd try this: =if(d5>.89,"A",if(D5>.79,"B",if(d5>.69,"C","Fail"))) Note how I used the numeric value rather than a

fiveminutelessons.com