Too many arguments to function in "if" function

[Kwnstantinos_M]

Hello

I wrote a formula in order to trace the boundaries of some wind values. The boundaries are 0-90 / 91-180 / 181-270 / 271-360, and in return I want to get 0 for the first group, 1,2,3 for the second,third and fourth respectively. The formula is the next one:

=if(R2<=90;0;;if(and(R2>=91;R2<=180);1;;if(and(R2>=181;R2<=270);3;;if(and(R2>=271;R2<=360);4;

The outcome is "too many arguments" . What do you think it's wrong?

(e.g. I use ; instead of , because my data had comma and there would be a problem with the calculations)

Thank you in advance

 

[dave2018]

THis works for me:

=IF(R2<=90,0,IF(AND(R2>=91,R2<=180),1,IF(AND(R2>=181,R2<=270),3,IF(AND(R2>=271,R2<=360),4))))

still not sure why u use ; instead of ,


___________________

edit: btw, if u have excel 2016, u can use this shortened version:

=IFS(R2<91,0,R2<181,1,R2<271,2,R2<=360,3)

 

[admiral100]

Hi,

Another way :

=LOOKUP(R2,{0,91,181,271},{0,1,2,3})

 

[Kwnstantinos_M]

Thank you very much... the problem obviously was that I was using 2 ";" instead of 1, after the if.. Thank you, it works!

 

[jtakw]

Hi,

Personally, I'd go with the LOOKUP as suggested by admiral100, but here's a shortened version of the IF formula, you Don't need any of the AND statements:

=IF(R2<=90,0,IF(R2<=180,1,IF(R2<=270,3,IF(R2<=360,4))))

 

[Kwnstantinos_M]

Thank you... yes it works too, and it's more simple.

 

[dave2018]

Hi,

Another way :

=LOOKUP(R2,{0,91,181,271},{0,1,2,3})

that is the most correct way

 

[jtakw]

Thank you... yes it works too, and it's more simple.

You're welcome, welcome to the forum.