| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
| Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Linear Mode
