Share via

IF Function symbols

Anonymous
2016-11-02T16:32:41+00:00

Hello, i have to try to use the IF function to put in grades for my assignment, but the function will not work with a plus sign following the grade, like if i try to say someone got a B+ or C+. How could i have excel recognize this problem?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-11-02T19:06:15+00:00

    Thanks Mike, I did what you said with putting the "" around the letters and the formulas worked out with the letters being read as text. Thanks again

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-11-02T17:24:41+00:00

    I also have the arguments closed at the end, reading:

    ,F))))))

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-11-02T17:22:33+00:00

    Mike: 

    my formula reads : =IF(K5>=90,A,IF(K5>=85,B+,IF(K5>=80,B,IF(K5>=75,C+,IF(K5>=70,C,IF(K5>=65,D,F

    where K5 is the cell reference I am starting with. Can you try to explain where I am suppose to put anything for the plus signs to show up in the formula. Thanks

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-11-02T16:48:38+00:00

    Hi,

    There isn't a problem and Excel should recognise those text strings, try it like this.

    =IF(OR(A1="B+",A1="C+"),"It's a B+or C+","It's neither")

    Was this answer helpful?

    0 comments