Hi Everyone,
I hope you all have had a good festive season and news years!
I am seeking some assistance with the following. I have muliple (9) statements which I wish to combine in to a single statement to determine a single value of "Major", "Moderate" or "Minor".
The 9 seperate statements which I need to combine are:
If(and(SOCValue=="Large",OSIValue=="Substantial"),"Major","")
If(and(SOCValue=="Large",OSIValue=="Reasonable"),"Major","")
If(and(SOCValue=="Large",OSIValue=="Minimal"),"Moderate","")
If(and(SOCValue=="Medium",OSIValue=="Substantial"),"Major","")
If(and(SOCValue=="Medium",OSIValue=="Reasonable"),"Moderate","")
If(and(SOCValue=="Medium",OSIValue=="Minimal"),"Minor","")
If(and(SOCValue=="Small",OSIValue=="Substantial"),"Moderate","")
If(and(SOCValue=="Small",OSIValue=="Reasonable"),"Minor","")
If(and(SOCValue=="Small",OSIValue=="Minimal"),"Minor","")
Any assistance would be greatly appreciated.
Thanks
