Advanced functions in Excel

Computer Science
Tutor: None Selected Time limit: 1 Day

Regarding Excel and working with advanced functions.  The question is:  Now think about nested IF statements. How will you set them up? An example would help

Oct 28th, 2014

In cell A3 let the value be say 3.9

In cell B3 enter the formula

=IF(A3>3.7,"A",IF(A3>2.7,"B",IF(A3>1.7,"C",IF(A3>0.7,"D","F"))))

Copy the formula across the rows 4 to 7

3.9 A
2.8 B
1.9 C
0.8 D
0.5 F

Oct 28th, 2014

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Oct 28th, 2014
...
Oct 28th, 2014
Feb 24th, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer