| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif and values greater than zero for a named range | Excel Worksheet Functions | |||
| How to check all three cells are greater than 0% and then lookup v | Excel Worksheet Functions | |||
| Cells turn colors if greater than specified values or pop up remin | Excel Discussion (Misc queries) | |||
| check for FALSE values in a range of cells in VBA | Excel Discussion (Misc queries) | |||
| Q: check a range values | Excel Discussion (Misc queries) | |||
Linear Mode
