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.