=IF(AND(A380,A3<85),3,"")


"Baz" wrote in message
...
I want to write a formula that gives a result in a cell if the value in the
target cell has a range of values. (i.e.) something like
IF (value in cell A3 has a value of 80 but <85, put a figure (e.g.) 3 in
the result cell or otherwise a zero.
Any help would be appreciated. Thanks in advance.
--
Baz Oz