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 :)


"alexrs2k" wrote in message
...
Holly Sh.. But you don't realize the simplicity and perfection of Jacob
response???

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

This is the best!!

--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"QuickLearner" wrote:

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.