excel nested if formula

Question

I am working on an excel file, and i am trying to use a nested if formula to achieve what i would like.

i have two columns:

A B

condition is this: if the value in a2=a3, then check if the minus of b2 and b3 is certain value, and if it is, put a yes, else put a no. this will iterate till the end of the excel file.

so far here is what i have. not sure how to use the excel formulas. any help is much appreciated.

if(a2=a3,b2-b3=5 or b2-b3=-5 or b2-b3=20 or b2-b3=-20, "yes", "no")

Bill · Accepted Answer · 2012-02-15 17:04:04Z

2

This works:

=IF(A2=A3,IF(OR(B2-B3=5,B2-B3=-5,B2-B3=20,B2-B3=-20),"yes","no"),"no")

answered Feb 15, 2012 at 17:04

Bill

25.6k8 gold badges100 silver badges129 bronze badges

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

1 Comment

VeeArr Over a year ago

Alternatively, instead of using a nested IF, you could just use an AND: =IF(AND(A2=A3,OR(B2-B3=5,B2-B3=-5,B2-B3=20,B2-B3=-20)),"yes","no")

barry houdini · Accepted Answer · 2012-02-15 17:42:17Z

1

Possibly use ABS function here..

=IF(AND(A2=A3,OR(ABS(B2-B3)={5,20})),"yes","no")

answered Feb 15, 2012 at 17:42

barry houdini

46.9k8 gold badges67 silver badges84 bronze badges

Collectives™ on Stack Overflow

excel nested if formula

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related