| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to write two criteria in if statement?
"Cindy Wang" wrote:
I have one more question: =IF(ISNUMBER(MATCH(M27,'[Sales Workpaper 2012.xls]May-12'!$A$8:$A$24,0))=FALSE, [....] Why you have to use a match funtion here for? Thought match is to look for position. I am not looking for any position here, am I? You originally wrote: =IF((VLOOKUP(M27,'[Sales Workpaper 2012.xls]May-12'!$A$8:$D$24,4,FALSE))=0, I misinterpreted your intent. Use your original conditional expression. One minor suggestion: eliminate the unnecessary parentheses. Just write: =IF(VLOOKUP(M27,'[Sales Workpaper 2012.xls]May-12'!$A$8:$D$24,4,FALSE)=0, More readable; ergo, less error-prone. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| better way to write a count if statement? | Excel Worksheet Functions | |||
| How do I write a compound if statement? | Excel Worksheet Functions | |||
| Hello I am trying to write an If/Then statement. Here is the data. | Excel Programming | |||
| how do I write the date in an if statement | Excel Worksheet Functions | |||
| How to write a statement about if then | Excel Programming | |||
![joeu2004[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
