If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to check if the values in a range of cells are greater than 0
Basically I want to check like IF(B3:B5 0,B1), if any of the values in B3
to B5 cells are greater than 0 then I take the value from the cell B1. How to do it in a simple way. If I use directly the above mentioned formula, it gives me a #VALUE error Thanks |
#2
|
|||
|
|||
How to check if the values in a range of cells are greater than 0
Try this:
=IF(COUNTIF(B3:B5,"0")0,B1,something_else) where you decide what you want the something_else to be (eg 0 or ""). Hope this helps. Pete On Mar 19, 10:19*am, DP wrote: Basically I want to check like IF(B3:B5 0,B1), if any of the values in B3 to B5 cells are greater than 0 then I take the value from the cell B1. *How to do it in a simple way. If I use directly the above mentioned formula, it gives me a #VALUE error Thanks |
#3
|
|||
|
|||
How to check if the values in a range of cells are greater than 0
Hi,
What do we do if nothing in b3:b5 is greater than zero? This formula does nothing =IF(MAX(B3:B5)0,B1,"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DP" wrote: Basically I want to check like IF(B3:B5 0,B1), if any of the values in B3 to B5 cells are greater than 0 then I take the value from the cell B1. How to do it in a simple way. If I use directly the above mentioned formula, it gives me a #VALUE error Thanks |
#4
|
|||
|
|||
How to check if the values in a range of cells are greater than 0
=IF(OR(INDEX(B3:B50,)),B1,"")
"DP" wrote: Basically I want to check like IF(B3:B5 0,B1), if any of the values in B3 to B5 cells are greater than 0 then I take the value from the cell B1. How to do it in a simple way. If I use directly the above mentioned formula, it gives me a #VALUE error Thanks |
Thread Tools | |
Display Modes | |
|
|