Hi mark,
See if this works:
A1 B1 C1
# # #
In D1 type
=IF(AND(A10,B10),C1,IF(AND(A1<0,B10),360-C1,IF(AND(A10,B1<0),180-C1,IF(AND(A1<0,B1<0),180+C1,"ERROR"))))
it worked for me.
HTH
cwilson
"mark.ew" wrote:
Hi there,
Could anybody please help me with a formula i am trying to enter into my
excel spreadsheet.
i have two sets of variables "a" and "b" which are related to each other.
Using a seperate formula I obtain "c" What i would like to do is apply 1 of
4 equations to "c" depending on the value of "a" and "b".
if "a"0 and "b"0 then "c" stays as it is
"a"<0 and "b"0 then minus"c" from 360
"a"0 and "b"<0 then minus"c" from 180
"a"<0 and "b"<0 then "c" plus 180
Is it at all possible to formulate the above??
Thanks for any help
Mark
|