# Nesting IF formula problem

Closed
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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