Hi Tina
=IF(OR(A1B1*(1+10%),A1<B1*(1-10%)),"Yes","No")
Note this excludes equal to +10% and -10% values themselves. Change to
= to include these values.
Regards
Roger Govier
tina wrote:
Hi
What is the best way to write if statement to show if cell A1 is 10% greater
or 10%smaller than cell B1
thanks
Pat
|