Help with an IF statement

  • Thread starter Thread starter punter
  • Start date Start date
P

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
 
punter said:
if the cell is question is blank
Click to expand...

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
 
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
 
Hy Punter,

try this

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

Hope this helps
Regards from Brazil
Marcelo


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

Eddie
 
Back
Top