 # Nesting IF formula problem [Closed]

-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I'm trying to set up a worksheet for student participation grades. Once I arrive at a participation average, I'd like to have a formula to read the average and return a value (e.g. If A2=9 then 100, If A2=8 then 95, etc.) This is what I've found from online:

=IF(AA2<1,0,IF(AA2<2,10,IF(AA2,3,20,IF(AA2<4,40,IF(AA2<5,60,IF(AA2<6,75,IF(AA2<7,85,IF(AA2<8,90,IF(AA2<9,95,100)))))))))

But I continually am getting errors: before an update to Office 365 I was getting an error about "nesting exceeding limits". After the update, the error changed to "too many arguments".

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
condition 1 is <1
condition 2 is <2 does this not include <1 also
perhaps what you are thinking is
aa2 between 1 and 2 then you have to use
if(and(aa2<2,aa2>=1)

if this is so change the formula
Recommended

DON'T MISS

TRENDING GAMES & APPS