Nested formula (I think?)

[Barrym]

I nedd a formula that says " if the value in cell a1 is between th
values of cell x5 and y5, then do this, if not do this"

I think it should start =if(between( .... but I'm lost after that.

Barr

 

[Peo Sjoblom]

=IF(AND(A1>=X5,<=Y5),"do this","if not do this")

you might want to remove the equal sign depending if you meant to include
the values in X5 and Y5, my formula includes them while if you remove the
equal signs
it will exclude them

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[DDM]

Barry, =IF(AND(A1>X5,A1<Y5),do this,do that) or
=IF(AND(A1>=X5,A1<=Y5),do this,do that)

 

[Jenny]

This assumes that values in column X are always less than
values in column Y.

If(and(A1>X5,A1<Y5),then....,else....)