| 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 |
| 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) | |||
Threaded Mode
