Excel if statement help

[cegarbage]

I have a valid, working excel formula that states:

=IF(BL17>=1,1,0)

However, I need it to say

If bl17 (or bl19) are greater or equal to 1, than 1, else 0

The or bl19 is really the only new part. How can I add that in with
correct syntax ?

 

[Don Guillett]

Just look in the help index for
OR

 

[Rick Rothstein \(MVP - VB\)]

Give this a try...

=IF(OR(BL17>=1,B>19>=1),1,0)

Rick

 

[Dave Peterson]

typo alert:

=IF(OR(BL17>=1,B119>=1),1,0)

or an alternative:

=--(OR(BL17>=1,B119>=1))

The -- stuff changes true to 1 and False to 0.

 

[Rick Rothstein \(MVP - VB\)]

Typo alert <g>

=IF(OR(BL17>=1,BL19>=1),1,0)

or

=--(OR(BL17>=1,BL19>=1))

The OP posted BL19, not B119.

Rick

 

[Dave Peterson]

Difficult for me to see with the font I use. (And I was too lazy to copy to
excel and use =upper()!)