I am trying to join a series of nested formulas and don't know if that is possible. Of course I have hit the limit and need to join 2 sets of nested formulas if possible. If someone would have any ideas please let me know. What I am doing is checking data in 2 cells and then computing a percentage based on the data inputed. This is my work in progress so far...
=IF(AND(X16=1,Y16="G"),0.045,IF(AND(X16=1,Y16="VG"),0.055,IF(AND(X16=1,Y16="E"),0.065,IF(AND(X16=2,Y16="G"),0.035,IF(AND(X16=2,Y16="VG"),0.045,IF(AND(X16=2,Y16="E"),0.055,IF(OR(Y16="RI",Y16="U"),0))))))))
I need to join the additional criteria with the difference being X16 becomes equal to 3 and 4 and goes through the same Y criteria.
Perhaps there is an easier way other than if statements???
This message was edited by wgreen on 2002-02-19 05:59
=IF(AND(X16=1,Y16="G"),0.045,IF(AND(X16=1,Y16="VG"),0.055,IF(AND(X16=1,Y16="E"),0.065,IF(AND(X16=2,Y16="G"),0.035,IF(AND(X16=2,Y16="VG"),0.045,IF(AND(X16=2,Y16="E"),0.055,IF(OR(Y16="RI",Y16="U"),0))))))))
I need to join the additional criteria with the difference being X16 becomes equal to 3 and 4 and goes through the same Y criteria.
Perhaps there is an easier way other than if statements???
This message was edited by wgreen on 2002-02-19 05:59