using IF THEN statements
 

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.

using IF THEN statements
 

Try this:

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

HTH,
Paul

wrote in message
ups.com...
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.

using IF THEN statements
 

The trick here is AND's syntax
=IF(AND(A20=10,B20=800),"YES","")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
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.

using IF THEN statements
 

That did it. Thanks.


PCLIVE (RemoveThis) wrote:
Try this:

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

HTH,
Paul

wrote in message
ups.com...
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.