View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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,