| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - If function meeting two criteria
I need to check a set of data against two criteria. I have a list of
currencies and a list of values. I need a formula that says - if X currency and - Y amount, then yes or no.. I have 5 different currencies so would need to do muliples if's in one formula... Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007 - If function meeting two criteria
Can you post a few lines of sample data and tell us what result you expect?
-- Biff Microsoft Excel MVP "SK08" wrote in message ... I need to check a set of data against two criteria. I have a list of currencies and a list of values. I need a formula that says - if X currency and - Y amount, then yes or no.. I have 5 different currencies so would need to do muliples if's in one formula... Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DGET Function - using a split criteria range? (Excel 2007) | Excel Worksheet Functions | |||
| How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
| calculation based on meeting two criteria | Excel Discussion (Misc queries) | |||
| how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
| COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions | |||
Linear Mode
