IF & OR functions

[ivory_kitten]

I have a function

=IF(OR(B9,B10,B11,B12)>0,"PBR","PBO")

B9:B12 are numerical values and the cell format is number.

If all the cells are blank the result is #VALUE!

If one of the cells has a number then the formula evaluates correctly and
displays text PBR

If I remove the OR part from the equation and just use one cell (e.g. B9 =
blank)

=IF(B9>0,"PBR","PBO") then the result is PBO

Why doesn't it work with the OR and blank cells?

[Bondi]

ivory_kitten wrote:
> I have a function
>
> =IF(OR(B9,B10,B11,B12)>0,"PBR","PBO")
>
> B9:B12 are numerical values and the cell format is number.
>
> If all the cells are blank the result is #VALUE!
>
> If one of the cells has a number then the formula evaluates correctly and
> displays text PBR
>
> If I remove the OR part from the equation and just use one cell (e.g. B9 =
> blank)
>
> =IF(B9>0,"PBR","PBO") then the result is PBO
>
> Why doesn't it work with the OR and blank cells?

Hi,

It looks like your function will work if you move your parentheses a
little on the OR expression:

=IF(OR(B9,B10,B11,B12>0),"PBR","PBO")

Regards,
Bondi

[Ardus Petus]

=IF(OR(--B9,--B10,--B11,--B12,"PBR","PBO")
will return PBO if any of B2:B12 <> 0 or BLANK

HTH
--
AP

"ivory_kitten" <[email protected]> a écrit dans le
message de news: [email protected]...
>I have a function
>
> =IF(OR(B9,B10,B11,B12)>0,"PBR","PBO")
>
> B9:B12 are numerical values and the cell format is number.
>
> If all the cells are blank the result is #VALUE!
>
> If one of the cells has a number then the formula evaluates correctly and
> displays text PBR
>
> If I remove the OR part from the equation and just use one cell (e.g. B9 =
> blank)
>
> =IF(B9>0,"PBR","PBO") then the result is PBO
>
> Why doesn't it work with the OR and blank cells?

[Dav]

if all you want is the maximum value of b9:b12>0

=if(max(b9:b12)>0,"PBR","PBO")

Regards

Dav

[ivory_kitten]

Thanks guys, I just needed if it is blank or zero.

"Dav" wrote:

>
> if all you want is the maximum value of b9:b12>0
>
> =if(max(b9:b12)>0,"PBR","PBO")
>
> Regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=561378
>
>

[daddylonglegs]

Assuming you won't have any negative values....

=IF(SUM(B9:B12),"PBR","PBO")