Nesting IF formula problem

Closed
ESLmichael - Jun 28, 2015 at 08:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 29, 2015 at 04:29 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 29, 2015 at 04:29 AM
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
0