|No Problem. |
For the IF statements, you would need to do an actual logical test. The code that you wrote was almost correct, but you had "," between the cell(s) that you wanted to test and the value that you wanted to test for. This is why it was giving you the error. If we look at the first part of what you wrote, it was looking at testing cell C4, but it didn't know what to test cell C4 for. Then the next thing it saw was "bronze" for the "Value_if_true" section, and "None" for the "Value_if_false" section. If you had stopped here, the formula would have returned a "#VALUE!" error. This is due to not having a valid logical test.
To fix the code in this example, you would use
=IF(C4="Bronze","None", IF(C4="Silver", 3000, IF(C4="Gold", 5000, IF(C4="Platinum", 10000, "Error"))))
Note that I included the "error" entry in there as you need something to ensure that if none of test result in a "true" outcome, that the formula does not throw an actual error.
Please let me know if you need more explanation. I hope I have helped you with your class. :)
Funny as I am teaching an Excel class tomorrow. :)
MOS Master Certified
CCNA Certificate Pending
A+ Certificate Pending
"I have gone to find myself. If I get back before I return, please tell myself to wait." :