Hi everyone. You guys are always a lot of help when I start hitting a wall!
Hope someone can help me again.

I am running XP Pro, SP2, and Office Professional 2003.

I am designing an invoice template for my company.
In cell A1, we enter either UPS or LTL (freight truck) for the shipping
method.
In cell A2, we enter the total amount of the order.
In cell A3, we enter the freight charge.

However, if the order can ship UPS, and the invoice total is more than $250,
the freight is N/C. If less than $250, we manually enter a freight amount.

If the order must ship freight truck (LTL), and the invoice total is more
than $400, the freight is N/C. If less than $400, we manually enter a freight
amount.

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.

Have I got you totally confused? I hope not.

Every time I've tried to build the formula I get most of it to work, but one
condition ends up returning FALSE in A3, which I don't want.

Thanks for any help you guys can give.
--
Jim