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

"David Biddulph" wrote:

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

"QuickLearner" wrote in message
...
I like Atishoo one

Now with true and false it should be like tis

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


"Atishoo" wrote in message
...
=AND(D3B3-B3/10, D3<B3+B3/10)

"Jacob Skaria" wrote:

In cell E3 try the below formula

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

If this post helps click Yes
---------------
Jacob Skaria


"Mark B" wrote:

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.