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 Luigi
IFS() is new in Excel 2016 (but only for Office 365 subscribers and in Excel Online).
And for your problem I would suggest a LOOKUP() formula.
Or CHOOSE()
- Hello Sergei,
Detlef suggested Lookup
I will also give Choose a go
Would this formula go something like this;
=choose(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")the choose option is not working either
May be I have the formula wrong or a parameter wrong
Here is a sample attached of what I am trying to achieve
