Is Cell D3 within 10% of B3 True or false?

[Mark B]

I have two Columns of Data,
I want to know if the Data in column D is within 10% + or - of the data in
column B
e.g Is Cell D3 within 10% of B3 True or false?
Should be simple but I can't figure it out.

 

[Bob Phillips]

Try

=AND(D3>B3*90%,D3<B3*110%)

 

[Jacob Skaria]

In cell E3 try the below formula

=ABS(D3-B3)/B3<=0.1

If this post helps click Yes

 

[Atishoo]

=AND(D3>B3-B3/10, D3<B3+B3/10)

In cell E3 try the below formula

=ABS(D3-B3)/B3<=0.1

If this post helps click Yes

 

[QuickLearner]

Usind AND function

=IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)>=-10))),TRUE,FALSE)

Rachad

 

[QuickLearner]

I like Atishoo one

Now with true and false it should be like tis

=IF((AND(D3>=B3*90%,D3<=B3*110%)),TRUE,FALSE)

 

[David Biddulph]

What added value do you think you get with =IF(...TRUE,FALSE) ?
What difference do you get with
=IF((AND(D3>=B3*90%,D3<=B3*110%)),TRUE,FALSE) compared with
=AND(D3>=B3*90%,D3<=B3*110%) ?
What values does the AND function return?

 

[David Biddulph]

What added value do you think you get with =IF(...TRUE,FALSE) ?
What difference do you get with
=IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)>=-10))),TRUE,FALSE)
compared with
=(AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)>=-10))) or with
=AND(((B3-D3)/B3)*100<=10,((B3-D3)/B3)*100>=-10) [having deleted a few of
the unnecessary parentheses] or with
=AND((B3-D3)/B3<=10%,(B3-D3)/B3>=-10%) [getting rid of the unnecessary
multiplication by 100] ?
What values does the AND function return? Doesn't it return the Boolean
TRUE and FALSE ?

 

[alexrs2k]

Holly Sh.. But you don't realize the simplicity and perfection of Jacob
response???

=ABS(D3-B3)/B3<=0.1

This is the best!!

 

[QuickLearner]

oops missed that one.
Real eye opener ..

I just started learning excel so I really did not get that first time..

what I did was using my limited imagination only backed by
IF,AND,OR,SUM,AVERAGE you get the idea

 

[QuickLearner]

you are right I am an idiot I admit.
My excuse I am learning and thanks for pointing out..

 

[Atishoo]

Blimey a simple question provokes a world war!!
I think everyone is waiting with baited breath to see which formula Mark b
will use!

there is nothing wrong with any of them! including quicklearners! If they
work then they are right!

But Jacobs is maths cancelled down to its minimum form therefore the best!
The equals sign means "this is the truth" and the less you put either side
of it the closer you are to the truth.

 

[Atishoo]

The question does say "within 10%" not within or equal to!

 

[Atishoo]

Quicklearners formula combining if with and could have an added value of
allowing the user to adapt the output, I know he requested "true or false"
but "buy or sell" or "cabbages and cauliflowers" could be more practical
outputs for the user! So dont be too hasty to criticise