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!.
Please help.
=IF(A2>=81,"A",IF(A2<>72-80,"B",IF(A2<71,"C")))
Need help setting up aging list using IF in excel 2007
days marked from 30 days 1-15 day 16- 30 day 31-90 and 90 day over.
I am already confused please help me with the correct formula.
Add new comment