IF Formula

L

LDanix

I am trying to create an IF formula. I want the column C to yield "Yes" if
the value in column A is plus or minus 3 of the value in column B and yield
"No" if not. Example of my data:

A B C
40 37 Yes
20 22 Yes
30 34 No
50 45 No

How would I achieve this?

Thanks!
 
B

Bob Phillips

Try this

=IF(ABS(A1-B1)<=3,"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

What do you mean> ABS is a worksheet function that returns the absolute
value of a number.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top