Thread: Is Cell D3 within 10% of B3 True or false?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andrea Jones Andrea Jones is offline
external usenet poster
  
Posts: 63
Default Is Cell D3 within 10% of B3 True or false?
=if(and(d3=90%*b3,d3<=110%*b3),TRUE,FALSE)

Andrea Jones
www.allaboutclait.com

"Mark B" wrote:

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?
Reply With QuoteReply With Quote