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,
|