Forum Discussion
Creating a IF, Then And formula
Im trying to create a formula that has multiple variables, I have 2 cells( A2 and B2), A2 can have different variables, for example A2 can = 100 or 200 or 300 or 400 or 500, Cell B2 must then change ...
If you have Office 365 of Excel 2019 versions, you can use the IFS function as follows:
=IFS(A2=100,200,A2=200,300,A2=300,400,A2=400,500,A2=500,600)
That will eliminate the Nested IF statement
=IFS(A2=100,200,A2=200,300,A2=300,400,A2=400,500,A2=500,600)
That will eliminate the Nested IF statement