Help with an IF statement

[punter]

Hi,

I'm knocking around the edges of a problem here but can't seem to find
the answer. The formula below works great but I want to add something
to it. I want it to return FedEx Weekly Charge if the cell is question
is blank and C2 = either 7 or 11. I have been trying various ISBLANKS
and IF formulas but I can't seem to get the right combination.

=IF(OR(C2=7,C2=11), "FedEx Weekly Charge", "")

Thanks

Eddie

 

[Mallycat]

if the cell is question is blank

what cell would that be? I assume you mean some cell other than C2!?

Assuming your 'possible blank cell' is B2, then this should work.

=IF(AND(OR(C2=7,C2=11),B2=""), "FedEx Weekly Charge", "")

Matt

 

[punter]

Thanks Matt. That worked perfectly. I knew I was close but wasn't sure
of the right combination to get it running.

Have a great day.


Eddie

 

[Guest]

Hy Punter,

try this

=IF(OR(C2=7,C2=11,C2=""), "FedEx Weekly Charge", "")

Hope this helps
Regards from Brazil
Marcelo


"punter" escreveu:

 

[punter]

Thank you very much. That will also work if I put in the parameters
that I'm looking for.

Eddie

 

[Guest]

thanks for the feedback

Marcelo

"punter" escreveu: