IF Formula

[Guest]

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!

 

[Dave O]

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

 

[Bob Phillips]

Try this

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

--

HTH

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

 

[SMD]

Try this

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

Hi,

In (ABS... what is the S in this formula?

Thanks.

 

[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)