Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
=IF(ABS(A1-B1)<=3,"Yes","No")
|
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Formula displays does not calculate | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |