IF and/or statement, true/false results different

[janesdtr]

Hello everyone,

I am having trouble constructing a formula that looks for either of 2 conditions and then returns different true and false values, depending on the conditions. I can successfully construct the formula when the true or false condition is the same for the 2 conditions, but can't wrap my head around this more complicated scenario.

Here I go:

If a2>0 AND c2=yes, then return a2*2 (if true) or a2 (if false)
OR
if b2>0 AND c2=yes, then return b2*2 (if true) or b2 (if false)

Thank you in advance for any advice you scoot my way!

Mary Beth

 

[janesdtr]

Thank you both for your solutions.

I had thought about adding the 2 cells as Hotpepper did, but worried about user errors where values would be entered in both the A and B columns. OTOH, a really big result in the formula cell would provide a clue that there were values in both A and B.

Villy, I was so narrowly focused on working the formula from left to right, that I didn't even consider using the "yes/no" column as the starting point for the IF statement. You redirected my brain.

Thank you both - I'll certainly use one of these. Nice to have options!

Mary Beth

 

[Scott Huish]

In that case:

=IF(A2,A2,B2)*IF(C2="yes",2,1)

Excel Workbook
	A	B	C	D	E
2	7	19			7
3	7		yes		14
4		10			10
5		11	yes		22
Sheet1

 

[villy]

You are preciously welcome though Hotpepper did a great formula there I also learned from that...