where can I find help with excel formulas?

T

trying to learn

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.
 
B

Biff

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
 
T

trying to learn

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!
 
B

Biff

You're welcome. Thanks for the feedback!

Biff

trying to learn said:
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!
Click to expand...
 
Top