I would like to write a nested if formula to do the following
Students have marks from 68% to 90%. The formula must do the following
If a student has 81% or more then they should get an "A". If a student has between 72 and 81% they should get a "B" and below 72% should get them in the C group.
My formula at the moment looks like this
=IF(AB2>=81;"1");IF(AB2<81;"B");IF(AB2<72;"C") but I get a #VALUE! number. I am not sure what I am doing wrong. If I just put in the first part of the formula IF(AB2>=81;"1") it work fine but anything else gives me a #value!.