You're welcome. Thanks for the feedback!

Biff

"trying to learn" wrote in message
...
Biff, what you wrote is perfect. If the conditions are not met, then 0 was
what I wanted. Thank you very much for your assistance!

"Biff" wrote:

What do you want to do if those conditions are not met?

Enter this formula in C1:

=IF(AND(A1=40,B1<=6),250,0)

If the conditions aren't met the formula will return 0.

Biff

"trying to learn" <trying to wrote in
message ...
I need a formula to fit this case...if a1=40 and b1<=6 then c1=250
What I'm trying to do is if A1 is 40 or more customers and B1 is 6
hours
or
less, then C1 will equate to 250.