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

  • Thread starter Thread starter Mark B
  • Start date Start date
M

Mark B

I have two columns of data.
I want to know if one column is within 10% of the second column.
E.g. Is Cell D3 within 10% + or - of B3?
 
Check your previous post..

In cell E1; (for boolean values)
=ABS(D3-B3)/B3<=0.1

In cell E1; (for text)
=IF(ABS(D3-B3)/B3<=0.1,"True","False")


If this post helps click Yes
 
Hi,

This returns TRUE/False

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

or to return text confirmation

=IF(ABS(B3-D3)/D3<=0.1,"Within 10%","More than 10%")


Mike
 
In what way does
=if(and(d3>=90%*b3,d3<=110%*b3),TRUE,FALSE)
have an advantage over
=and(d3>=90%*b3,d3<=110%*b3) ?

Doesn't the AND function return a Boolean TRUE or FALSE result?
 
Hello All,
I think Mike H's answer below is the best fit.
I did eventually figure out the following which also seems to work:
=IF(ABS(X14)>(V14*1.1),"x","")
Puts an X in the column if it is greater than V14+10%
Does anyone have a preference for one solution over the other?
 
Back
Top