"Ms MIS" wrote in message
...
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

=IF(AND(A1="SJN",C1="SJN"),B1+D1,
IF(AND(A1="SJN",C1<"SJN"),B1,
IF(AND(A1<"SJN",C1="SJN"),D1,)))

Ciao
Brunio