A B c d E
1 36.02 87.98 103.87 n/a
2 2.14 3.4 4.51 n/a
3 22.56 34.85 57.29 n/a
4 15.85 30.82 46.36 -50.5

In E1 i want to calculate, if d1 is n/a then check c2; if d1 is negetive then print n/a in e1. if not then E1 will be same as d1.

Now check c2; if c2 is N/a then check b2 ; if c2 is negetive then print N/a in e1. if not then e1 will be the (c1/9)*12.

Now Check B2; if B2 is N/a then check a2; if b2 is negetive then Print N/a in e1. if not then e1 will be the (b2/6)*12

Now check a2; if a2 is N/A or negetive then Print in e1 N/A. if not then e1 will be (a1/3)*12.

If anyone can to solve this then plz help me.