Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif when the give or take a couple...
I'm trying to write an equation that will provide a yes or no statement if
the value between two cells is equal or less than three. This is what I'm trying but it's not working....=IF(S2<=R2-3, "Yes", "No") Any ideas? Many thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif when the give or take a couple...
You haven't told us in which way it isn't working, and sadly for some of us
our clairvoyant powers are limited. What values are in R2 and S2 respectively? Are you sure that these cells contain numbers, not text? No spurious spaces? What value does your formula return? If you are looking for R2 and S2 to be within 3 of each other in either direction, you could use =IF(ABS(R2-S2)<=3, "Yes", "No") -- David Biddulph "Bill D. Toronto" wrote in message ... I'm trying to write an equation that will provide a yes or no statement if the value between two cells is equal or less than three. This is what I'm trying but it's not working....=IF(S2<=R2-3, "Yes", "No") Any ideas? Many thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif when the give or take a couple...
Try
=IF(R2-S2=3, "Yes", "No") "Bill D. Toronto" wrote: I'm trying to write an equation that will provide a yes or no statement if the value between two cells is equal or less than three. This is what I'm trying but it's not working....=IF(S2<=R2-3, "Yes", "No") Any ideas? Many thanks, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif when the give or take a couple...
I'm not sure I understand exactly what you're looking for, but see if this
works. =IF(ABS(R2-S2)<=3,"Yes","No") If the two cells (R2 and S2) are within 3 of each other, then "Yes" is returned. HTH, Elkar "Bill D. Toronto" wrote: I'm trying to write an equation that will provide a yes or no statement if the value between two cells is equal or less than three. This is what I'm trying but it's not working....=IF(S2<=R2-3, "Yes", "No") Any ideas? Many thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Couple of Questions | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
A couple of questions... | Excel Discussion (Misc queries) | |||
Couple more questions... | New Users to Excel | |||
There are a couple of parts to this ???...Thank you for the help. | Excel Worksheet Functions |