Assign Land Class based on the Four Selected option

I want to assign the land class based on the four options selected, the XML values analyzed, and the highest among all is my land class.
aCpKUgX3PqM4cf9kZMMyxz.xlsx (7.0 KB)

Hi @dscndb001 and welcome back to the community!

What’s the critearia for land classes? Right now in your calculation question you only wrote calculation rather than any formula.

highest xml value given in the choice sheet from selected options is the class

Can you provide some examples? So we can try to create the formulation behind that selection.

Max xml value among the selected option will be my class for that survey.

Land Classification Sheet.xlsx (502.5 KB)
Sheet for your reference

calculations are done in the excel sheet…