Try this:
For values in Row 2:
E2: =(A2="SJN")*B2+(C2="SJN")*D2

Does that help?

***********
Regards,
Ron


"Ms MIS" wrote:

I have a worksheet with 5 columns (A-E)
I want to create a formula in column E to do the following;

If column A = SJN and column C = SJN
Then output B+D
Else If column A = SJN and column C < SJN
Then output B
Else If column A<SJN and column C = SJN
Then output D

Can anyone help me?
Thanks.