Forum Discussion
Excel
How do I get this nested IF to work =IF (D5 >= 5000, “Gold” , IF(D5>= 2000, “Silver”, “Bronze”))
Two things to do:
- Remove the space after the first "IF". There should be no space between a function name and its opening parenthesis.
- Replace the special quotation marks (Double Turned Comma Quotation Mark and Double Comma Quotation Mark, as Unicode calls them) with normal quotation marks.