| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Criteria = 1
I am looking for help with a formula. Write now if Sheet1 has a 10 in cell
K4, and I put this formula {=IF('Sheet1'!K4="10",1,""} in cell P4 the number 1 will be displayed in cell P4. I wanted to modify the formula so that if cell J4 displays Apples and K4 displays 10 (assuming I put the formula in P4 again) a 1 will be displayed in cell P4. Thank you for your ideas. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
