#### Kwnstantinos_M

##### New Member

- Joined
- Jun 12, 2018

- Messages
- 24

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