From: DP on 19 Mar 2010 06:19 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 From: Pete_UK on 19 Mar 2010 06:24 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 From: Mike H on 19 Mar 2010 06:53 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 From: Teethless mama on 19 Mar 2010 09:31 =IF(OR(INDEX(B3:B5>0,)),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  |