Hi, here is the problem. In following table at the place of "Angle" I fetch data using following formula.
<tbody>
</tbody>
Now at "Aspect Dg" I tried using following formula with IF statement but its not working.
It always showing me 60, if "Angle" is not "Ingress"
Please help. Both all columns are in general format.
Regards
Code:
=IF(A2 = "<<<","Ingress",LEFT(A2, SEARCH(" ",A2,1)))
Description | Angle | Aspect Dg |
<<< | Ingress | |
Trine Venus | Trine |
<tbody>
</tbody>
Now at "Aspect Dg" I tried using following formula with IF statement but its not working.
Code:
=IF(B2 ="Ingress","None",IF(B2 ="Trine", 120,IF(B2 ="Conjunction",0,IF(B2 ="Opposition",180,IF(B2 ="Square", 90, 60)))))
It always showing me 60, if "Angle" is not "Ingress"
Please help. Both all columns are in general format.
Regards
Last edited: