ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF formula using a range of values in a cell (https://www.excelbanter.com/excel-worksheet-functions/174405-if-formula-using-range-values-cell.html)

Baz

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

Gary

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




Pete_UK

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 -



Max

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


Stefi

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


Mike H

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


Baz

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


Teethless mama

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



All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com