| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I set up an argument which asks for multiple criteria
I am trying to use an argument that asks for one of three criteria (2345P,
8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet another cell, G108 into cell K108, and if not enters 0 into cell K108. It seems there are too many arguments for the "if" argument, and I can't seem to get the "lookup" argument to work either. Is there another argument I should be working with? Thanks -- Diver |
|
#2
|
|||
|
|||
|
Try:
=IF(OR(C108="8319T",C108="2345P",C108="7026J"),G10 8,0) "bj" wrote: try in K108 =if(or(c108="2345P",C108="8319T",C108="7026J"),G10 8,0) "HiTekDiver" wrote: I am trying to use an argument that asks for one of three criteria (2345P, 8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet another cell, G108 into cell K108, and if not enters 0 into cell K108. It seems there are too many arguments for the "if" argument, and I can't seem to get the "lookup" argument to work either. Is there another argument I should be working with? Thanks -- Diver |
|
#3
|
|||
|
|||
|
try in K108
=if(or(c108="2345P",C108="8319T",C108="7026J"),G10 8,0) "HiTekDiver" wrote: I am trying to use an argument that asks for one of three criteria (2345P, 8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet another cell, G108 into cell K108, and if not enters 0 into cell K108. It seems there are too many arguments for the "if" argument, and I can't seem to get the "lookup" argument to work either. Is there another argument I should be working with? Thanks -- Diver |
|
#4
|
|||
|
|||
|
One mo
=IF(OR(C108={"8319T","2345P","7026J"}),G108,0) HiTekDiver wrote: I am trying to use an argument that asks for one of three criteria (2345P, 8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet another cell, G108 into cell K108, and if not enters 0 into cell K108. It seems there are too many arguments for the "if" argument, and I can't seem to get the "lookup" argument to work either. Is there another argument I should be working with? Thanks -- Diver -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| text argument in vlook up which has a "" | Excel Worksheet Functions | |||
| read in Vlookup an argument that has quotations(") | Excel Discussion (Misc queries) | |||
| OFFSET using ADDRESS for the reference argument | Excel Worksheet Functions | |||
| how to copy the function argument box onto word | Excel Discussion (Misc queries) | |||
Linear Mode
