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

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Oct 28th, 2014
...
Oct 28th, 2014
May 29th, 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