using IF THEN statements

[goldcomac]

I'm in over my head on this one.

I've got a file that tracks accounts and gallons. The target is 10
accounts and 8000 gallons. I'm trying to write a formula that says "If
A20 >= 10 AND B20>=8000 then YES, othewise ""). I can do the A20 & B20
piece individually, but don't know how to put them together.

Thanks.

 

[PCLIVE]

Try this:

=IF(AND(A20>=10, B20>=8000),"Yes","")

HTH,
Paul

 

[Bernard Liengme]

The trick here is AND's syntax
=IF(AND(A20>=10,B20>=800),"YES","")
best wishes

 

[goldcomac]

That did it. Thanks.

Try this:

=IF(AND(A20>=10, B20>=8000),"Yes","")

HTH,
Paul