Welcome Guest.

4Answers

How do you get the if function?

Asked by: John 161 views IT April 9, 2019

Addition: Come on

4 Answers

  1. +4Votes  

    According to your form, it should be

    GPA:=IF(C3>=80,4,IF(C3<60,0,3))

    Credit:= IF(C3>=60,2,0)

    Donald Davies- April 10, 2019 |

  2. +5Votes  

    credits  IF(C3<60,0,2)      GPA FB(B2<60,0,IF(B2<80,3,4))

    Answer: GPA is changed to C3 on your form b2

    Lisa- April 10, 2019 |

  3. +5Votes  

    The conditions here need to be based on the data in the cell.

    Anna Young- April 10, 2019 |

  4. +5Votes  

    Syntax: IF(logical_test, value_if_true, value_if_false) 

    In the dialog popped up by IF, the logical_test option fills in the condition, and the value_if_true option fills in the true condition. The returned value, value_if_false option fills in the value returned as false

    Question: Help to play the function

    Jason Hughes- April 10, 2019 |