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

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

Secure Information

Content will be erased after question is completed.

Enter the email address associated with your account, and we will email you a link to reset your password.

Forgot your password?

Sign Up