Using an OR in an IF Function

[bmartin2]

I'll try to phrase my question as clearly as I can so that you wonderful people can help me!

I have Column A and Column B with Data, Column C is where I want to do the Formula and Column D is where I have the labels.

Column D is where we label a certain piece of business as registered, hold, order, walked, passed or moved.

I want to have column C calculate A/B if Column D is labeled as registered, order or hold. If Column D isn't labeled as registered, order or hold, I want a zero in Column C.

When I try to add the OR into the formula, I'm getting errors out the wazoo.

So what should my formula be?


As a sub question, if the formula includes "registered" will it pick up "Registered" or "REGISTERED" or is it caps sensitive?

Thank you so much!

 

[lenze]

=IF(OR(D2={"registered","order","hold"}),A2/B2,0)

lenze

 

[SteveO59L]

=IF(OR(D1="registered",D1="order",D1="hold"),A1+B1,0)

 

[Swift_74d]

I want to have column C calculate A/B if Column D is labeled as registered, order or hold. If Column D isn't labeled as registered, order or hold, I want a zero in Column C.

Should be

=if(or(d1="registered",d1="order",d1="hold"),a1/b1,0)

cant test it right now because i'm not at a computer with excel however the above is assuming that your data starts in row 1.

 

[bmartin2]

Thank you! Got it to work