Prev: IF statement based on True/False that activates a certain list box
Next: a Counting question
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 <D...(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: IF statement based on True/False that activates a certain list box
Next: a Counting question