Thank you for the explanation

As I have more than 10000 posts in one forum or another, I know what A1>0 means thank you
Would you please be so kind to explicitate what the outcome is when conditioons are met
In XL there is no A and B, but A1 or B20

Your examples of outcome when A1 <0 are a complete mystery to me. I cannot understand your logic.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sorry for the confusion

What I meant is:

If A2 is positive and B2 is positive then C2=
If A2 is positive and B2 is negative then C2=
If A2 is negative and B2 is positive then C2=
If A2 is negative and B2 is negative then C2=

Thanks

Best

Jamal

Sorry you don't seem to understand my question
Hope someone else can help you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Attached Images

Clip_17.jpg (64.6 KB, 43 views)

Attached Files

MF_02.xlsx (9.4 KB, 9 views)