Quote:
Originally Posted by Pecoflyer
Sorry you don't seem to understand my question
Hope someone else can help you
|
Thank you for the prompt help.
Apologies to not be able to well explain what I want. If you allow me, I’ll be trying to explain what I need once more.
Please, consider the values of A and B and the calculated value of X (attached)
These calculations are made based on the conditions below
if A>0 and B>0 then X=A+B
If A>0 and B<0 then X=A-B
If A<0 and B>0 then X=2*A-B
If A<0 and B<0 then X=3B-A
My issue here is that I couldn’t code these conditions in excel
Best
Jamal