Hey thanks Bruce, Michael, and Bruno. You guys saved my butt (and my brain!).
--
Jim


"Bruno Campanini" wrote:

"Jim" wrote in message
...

Hi everyone. You guys are always a lot of help when I start hitting a
wall!
[...]
I need a formula for cell A3.

I want it to return "N/C" if A2400 and A1="LTL", or if A2250 and
A1="UPS".
In all other situations I want it to return a blank ("") cell which will
prompt us to enter a freight amount.

It should be:
=IF(OR(AND(A2400,A1="LTL"),
AND(A2250,A1="UPS")),"N/C","")


Bruno