Vasylian223
New Member
- Joined
- Apr 30, 2020
- Messages
- 3
Hello.
I'm currently doing a project, in which i must do something like this:
If value of a cell, let's say B4 is less than 1.5 it is "1", if it's Equal to or Greater than 1.5 BUT Less than 2.5, it is "2", if it's Equal to or Greater than 2.5 BUT Less than 3.5, it is "3"... until if it's Equal to or Higher than 4.5 but not greater than 5 then it's "5"...
The formula i would use is:
IFS(B4<=1.5,"1",B4>=1.5<2.5,"2",B4=2.5<3.5,"3",B4>=3.5<4.5,"4",B4>=4.5<5,"5")
but the formula doesn't work and it results in #N/A.
What would correct formula be for that?
I'm currently doing a project, in which i must do something like this:
If value of a cell, let's say B4 is less than 1.5 it is "1", if it's Equal to or Greater than 1.5 BUT Less than 2.5, it is "2", if it's Equal to or Greater than 2.5 BUT Less than 3.5, it is "3"... until if it's Equal to or Higher than 4.5 but not greater than 5 then it's "5"...
The formula i would use is:
IFS(B4<=1.5,"1",B4>=1.5<2.5,"2",B4=2.5<3.5,"3",B4>=3.5<4.5,"4",B4>=4.5<5,"5")
but the formula doesn't work and it results in #N/A.
What would correct formula be for that?