Excel if statement help

  • Thread starter Thread starter cegarbage
  • Start date Start date
C

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 ?
 
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.
 
Typo alert <g>

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

or

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

The OP posted BL19, not B119.

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