View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] goldcomac@mac.com is offline
external usenet poster
 
Posts: 30
Default 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.