=IF(AND(E7<"A",E7<"B"),"FOUND","")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anandmr65" wrote
in message ...

Hi,
I am having a column with different values in different cells. I want
to populate the adjacent cell with either blank or a value for
eg."Found". So if the cell has the values "A" or "B" then populate the
adjacent cell with blank else if the values or anything other than "A"
and "B" then populate it with "Found". I tried this formula
IF(E7<"A",IF(E7<"B","FOUND","")), but this does not work.
Could somebody help me with this formula.

Thanks & REgards
Anand


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=533366