Hi

I have the following formula in excel which I can't seem to translate to deluge:

 

=IF(AND(B3>2,C3>2),"MANAGE",IF(AND(B3>2,C3<3),"INFORM",IF(AND(B3<3,C3>2),"SATISFY",IF(AND(B3<3,C3<3),"MONITOR"))))

 

I understand the AND needs to be translated to &&, but the multiple 'IF's and comments are the problem.

 

e.g. where B3 is a user input ranked 1 to 5 (drop down list) and C3 is a user input ranked 1 to 5 (drop down list), should this be a comment script or a formula script?

 

thx :)