Formula to answer YES or No
On Tuesday, March 25, 2014 2:23:05 PM UTC-2:30, wrote:
Hi-
I want to create a field that will give a "YES" or "No" if the number in CEll A1 is not 15 percent higher or lower than cell A2 "YES"
Thanks,
Paul
Claus,
Thanks for the help!
Don't seem to be working right, but may be what i have for the percentage of the difference formula
VAL= =IF(C8="","",(((C8-D8)/ABS(D8))))
c8=1.56
d8=1.86
e8=-16%
f8 = yes
b3=12%
|