If Statements - Multiple formulae
Nothing against the other solutions, but I like this one.
"Ron Coderre" wrote:
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.
|