Thread: How to check if the values in a range of cells are greater than 0
View Single Post
  #4  
Old March 19th, 2010, 01:31 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
  
Posts: 3,722
Default 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