IF formula using a range of values in a cell
 

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

IF formula using a range of values in a cell
 

=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

IF formula using a range of values in a cell
 

Or even:

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

Pete

On Jan 25, 11:40*am, "Gary" wrote:
=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- Hide quoted text -

- Show quoted text -

IF formula using a range of values in a cell
 

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

IF formula using a range of values in a cell
 

=IF(AND(A380,A3<85),3,0)
Regards,
Stefi


€žBaz€� ezt Ã*rta:

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

IF formula using a range of values in a cell
 

Perhaps

=IF(AND(A3=80,A3<=85),3,0)

Mike

"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

IF formula using a range of values in a cell
 

--
Baz Oz


"Gary" wrote:

=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

Thanks for help - I appreciate it. Baz

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