IF value is in range

  • Thread starter Thread starter Kirsty
  • Start date Start date
K

Kirsty

I am trying to write a formula or macro that returns a result if a value is
in a range.
I can write the lookup fine, but i am getting data errors if there is no
value.

What i want to do is put an IF statement in that states
IF(date,is in range,then,0)

Can anyone help
 
Something like this:

=if(and(a1>date(2009,1,1),a1<date(2009,2,1)),"in range","out of range")

?

Regards,
Fred.
 
Hmmm....
returns a result if a value is in a range.
Click to expand...

Returns what result?

Try something like this:

=IF(COUNTIF(A1:A10,X1),"Yes, it's there","No, it's not there")
 
Back
Top