Forum Discussion

Iron Contributor

Oct 24, 2021

Decision table (without nested IFs or Power Query)

I have a decision table (https://en.wikipedia.org/wiki/Decision_table) that I would like to use in Excel. I know how to implement it using nested IFs or Power Query, but is there a simple and effic...

question-decision-table.xlsx12 KB

excel

Formulas and Functions

Yea_So

Bronze Contributor

Oct 24, 2021

bartvana

Nothing is simple in excel, however you can setup a data model and use measures either in power pivot or Power-Bi to generate your dashboard or report to get the desired results.