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


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553174

punter Wrote:
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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553174

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


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553174

Hy Punter,

try this

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

Hope this helps
Regards from Brazil
Marcelo


"punter" escreveu:


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


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553174

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

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553174

thanks for the feedback

Marcelo

"punter" escreveu:


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

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553174