It's not clear what is SJN, so I supposed it's a string. Type in E1 and fill
down as needed:

=IF(AND(A1="sjn",C4="sjn"),B1&D1,IF(AND(A1="sjn",C 1<"sjn"),B1,IF(AND(A1<"sjn",C1="sjn"),D1,"not thought of")))

Regards,
Stefi

€žMs MIS€� ezt Ã*rta:

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.