"a" "b" "c" are indicative only. I have true numerical values for them. What
i would like to do is enter a formula, that would have excel analyse cells
"va" and "vb" and then depending on the permutations of "va" and "vb" being
positive or negative, apply one of the equations. I have a couple hundred
sets of "va" and "vb" cells, so it would save alot of time, if it was
possible to enter a formula, rather than manually checking each set.
Is it possible to input one formula that contains all four equations below,
but that would only apply the correct one based on positives and negatives of
"va" and "vb"

"Don Guillett" wrote:

I suggest changing your variable names to va, vb,vc and then nesting the
if's

--
Don Guillett
SalesAid Software

"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