I'm trying to create a formula to get a cell outcome based on multiple different variables that are number of text.
So the outcomes could be
And these outcomes based on multiple variables like:
Product amount two
The outcomes would be different based on the "product type", "product spec", if product amount two is less than "product amount", or above "product amount" another outcome.
Also dependent on the variables I would like the possibility to be able to combine outcomes.
Help would greatly be appreciated.