Forum Discussion
Solved
Multiple conditions case
Working on excel workbook where I want to see a value(Column1) in Column 12 if value in Column 3= C1 and If value in Column 2 is >=C31 and if value in Column 2 is <=D3 . Above 3 conditions which are ...
Use =IF(AND(condition 1, condition 2, condition 3),result if all true, else)
IFS is for a series of possible conditions with corresponding results, as in
=IFS(condition 1, result 1, condition 2, result 2, condition 3, result 3..,....)
Use =IF(AND(condition 1, condition 2, condition 3),result if all true, else)
IFS is for a series of possible conditions with corresponding results, as in
=IFS(condition 1, result 1, condition 2, result 2, condition 3, result 3..,....)
- Thanks @Mathets (Y)
