Passed or Failed, I Failed at excel.

Hello guys,

I posted in here a few months back and the outcome was great so I thought I post again my problem. I have found that now that I know some stuff about excel, I want to use it for anything I need to do. Anyways, I have attached the spreadsheet here so you guys can see my problem but let me explain. This is basically an spanish-english test for my father, it has 2 tabs, Questions & Vocabulary. On both tabs I got formulas to count the correct answers and the wrong answers, so then I divide it to make it percentage wise. My problem is I have a formula that I want to do the following, if the score is 80% or higher, I wanted to add the word PASSED and if its less than 80%, obviously would be FAILED. All that works perfectly fine, however, when there 0% and there is no wrong or correct answer's counted, I wanted to show READY but I cannot seemed to make it happen. Can somebody please take a look at it and possibly help me? that would be tremendously helpful. I also attached the answer to the vocabulary just in case you need it for testing purposes and theres nothing wrong with learning a little bit on the side either hahahaha.

Thank you in advance.

You need to change the formula in O13 to this:

=IF(O12=0,0,O11/(O11+O12))

i.e. get rid of the quotes around the second zero, then you can have this formula in M14:

=IF(O13=0,"READY",IF(O13>=80%,"PASSED","FAILED"))

Hope this helps.

Pete