One way
In say, B3: =IF(AND(A380,A3<85),3,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Baz" wrote:
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