Nesting IF formula problem [Closed]

Report
-
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".

Please advise. Any input is appreciated!


1 reply

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