Thread: if cell A is +- 10% of cell B
View Single Post
  #3   Report Post  
vezerid
 
Posts: n/a
Default
Roger,

I believe the phrasing in Tina's request contains an OR, but what she
really means is

=IF(AND(A1<B1*(1+10%),A1B1*(1-10%)),"Yes","No")

HTH
Kostis Vezerides

Reply With QuoteReply With Quote