IF Formula
 

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!

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

Try this

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

--

HTH

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


"LDanix" wrote in message
...
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!

On Tue, 11 Jan 2005 23:32:05 -0000, "Bob Phillips"
wrote:

Try this

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

Hi,

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

Thanks.

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)


"SMD" wrote in message
...
On Tue, 11 Jan 2005 23:32:05 -0000, "Bob Phillips"
wrote:

Try this

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

Hi,

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

Thanks.