If Excel.doc - IF Condition IF(logical_test,value_if_true,value_if_false Example 1 =IF(A2<=100\"Within budget\"Over budget If the number above is less

If Excel.doc - IF Condition...

This preview shows page 1 out of 1 page.

IF Condition IF(logical_test,value_if_true,value_if_false) Example 1 =IF(A2<=100,"Within budget","Over budget") If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget) =IF(A2=100,SUM(B5:B15),"") If the number above is 100, then the range B5:B15 is calculated. Otherwise, empty text ("") is returned () Example 2 If A2 > 89 cell appear A If 89>A2>79 cell appear B If 79>A2>69 cell appear C If 69>A2>59 cell appear D If A2<=59 cell appear F Equation will be : =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) Assigns a letter grade to the first score (F) =IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F")))) Assigns a letter grade to the second
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Fall '17
  • Expression, Equals sign

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes