Forum Discussion
Help with this "IFS" statement in office 365
I looked up how to write this statement, found a solution on the web (Example 2) see attached image I typed the exact same information into my spreadsheet using the formula shown. and get a differe...
Hello Detlef,
I am an Office 365 subscriber.
I will try the Lookup option and let you know.
Would it go like this;
=lookup(E8=1,B3="Whey"),15,AND(E8=1,B3="Milk”),15,AND(E8=1,B3="Cheese"),15,AND(E8=1,B3="Butter"),15,AND(E8=1,B3="Meat"),20,AND(E8=1,B3="Bones"),25,AND(E8=1,B3="Grass"),15,AND(E8=1,B3="Water")
I am an Office 365 subscriber.
I will try the Lookup option and let you know.
Would it go like this;
=lookup(E8=1,B3="Whey"),15,AND(E8=1,B3="Milk”),15,AND(E8=1,B3="Cheese"),15,AND(E8=1,B3="Butter"),15,AND(E8=1,B3="Meat"),20,AND(E8=1,B3="Bones"),25,AND(E8=1,B3="Grass"),15,AND(E8=1,B3="Water")
I am an Office 365 subscriber.
Then IFS() should work.
For the lookup formula create a helper table in E12:F19 with the products in column E and the values in column F. Column E must be sorted in ascending order.
=LOOKUP(B3,$E$12:$F$19)