IF formula using a range of values in a cell
=(A380)*(A3<85)*3
"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
|