Hello
I have 5 seperate dropdown options which allows you to select 1 to 5 range.
My idea is to come up with a EndResult depending on the selected options.
The criteria to meet the EndResult: X | Y | Z
X means if Option1 is either 4 or a 5
Y means if Option1 is either 2 or 3 AND Option3 is 4 or 5
Z means if Option1 is either 3 or 2 or 1 AND Option3 is either 3 or 2 or 1 AND Option5 is either 4 or 5
Anything else outside the above range is "Normal"
How to do that? It requires nested IF statements and I get lost in it.
My initial start ... :
if(or(Option1=="4", Option1=="5"),"Big", "Normal")
Would appreciate your advise.