Excel, multiple if statements

Question

I'm in over my head on this one. Can anyone write an if statement for one cell with the following conditions:

if BB>0, B6>0, BA<-.3, BA>-1.2 THEN O11-.1
if BB>0, B6<0, BA>.3 THEN O11+.1
Leave cell blank if neither condition is met.

Is this possible? Thanks

for 1 and 2 do all conditions have to be met, or just one?

guitarthrower
– guitarthrower

2009-10-21 18:45:16 +00:00
Commented Oct 21, 2009 at 18:45 — guitarthrower
– guitarthrower, Commented Oct 21, 2009 at 18:45

guitarthrower · Accepted Answer · 2009-10-21 18:56:18Z

1

=IF(AND(BB>0,B6>0,BA<-.3,BA>-1.2),O11-.1,IF(AND(BB>0,B6<0,BA>.3),O11+.1,""))

The above formula should do the trick. The only thing I'm having trouble understanding is what are BB and BA? Are they named cells? If not they are not valid cell references and could cause problems in the formula.

answered Oct 21, 2009 at 18:56

guitarthrower

5,9143 gold badges33 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel, multiple if statements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related