Forum Discussion
formula with many conditions using greater than less than and equal to in spreadsheet
I am having an error with a formula that has result conditions with multiple arguments. In the equation I am trying establish the following: if column "B" is 1 but less than 5 result in Column "C" i...
Data_clerk The IFS function could be used to use no nested IF statements:
Since it stops after it finds a value that meets the condition, there's no need to use AND clauses to check if values are between specific values.
=IFS(B2<1, 0, B2<5,2,B2<10,3,B2<25,4,TRUE,5)
Just keep in mind that IFS is only available in Excel 2019 or O365.
This equation has worked as well. there seems to be multiple ways to get the same result. macrordinary
