Thank you Roger
I did mean "or" as trying to find out if a difference between 2 numbers is
greater than 10%
Thank you Kostis for your time
Tina
"Roger Govier" wrote:
Hi Kostis
Maybe.
The OP now has both solutions and can decide which suits her requirements.
Regards
Roger Govier
vezerid wrote:
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
|