Excel say "you have entered too many arguments for this function excel"

[medo82006]

=IF(H2<0.25,"C1",IF(AND(H2>0.25,H2<=0.75),"C2",IF(AND(H2>0.75,H2<2.25),"C3"),IF(H2<2.25,"C4")))

Excel say "you have entered too many arguments for this function excel"

how can i solve this problem?

thank you

[FDibbins]

you have a parenthesis in the wrong place....
=IF(H2<0.25,"C1",IF(AND(H2>0.25,H2<=0.75),"C2",IF(AND(H2>0.75,H2<2.25),"C3"),IF(H2<2.25,"C4")))

=IF(H2<0.25,"C1",IF(AND(H2>0.25,H2<=0.75),"C2",IF(AND(H2>0.75,H2<2.25),"C3",IF(H2<2.25,"C4"))))

Or (without seeing what you are trying tio do, this...
=IF(H2<0.25,"C1",IF(H2>0.25,IF(H2<=0.75,"C2",IF(H2<2.25,"C3",IF(H2<2.25,"C4")))))

[medo82006]

Thank you to the speed of response

[FDibbins]

did that solve your question?

[medo82006]

=IF(ISERROR(IF(I2<=10,"S1",IF(AND(I2>10,I2<=18),"S2",IF(AND(I2>18,I2<=25),"S3",IF(I2<25,"S4"))))),"",IF(I2<=10,"S1",IF(AND(I2>10,I2<=18),"S2",IF(AND(I2>18,I2<=25),"S3",IF(I2<25,"S4")))))

i use IF(ISERROR but given (false). why?

[medo82006]

Yes, Thank you to the speed of response