Just another option:

=CHOOSE(2*(a0)+(b0)+1,c+180,360-c,180-c,c)

However, if a,b, & c are angles, then there may be a more simplified
solution.

--
Dana DeLouis
Win XP & Office 2003


"mark.ew" wrote in message
...
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