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, |
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, |
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, |
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, |
All times are GMT +1. The time now is 03:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com