| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine an And OR function
I have a little function that i need help with.
=IF(AND($B9="Z",AE9=35,J9=1),1000). This function works fine, however I need to add in somehow that J9 could equal M or 1 or C and I would like the function still to be true and return the value as 1000. As I see it, this is smoehow combining and AND OR statement but I cant get it to work. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine Combo Box function with Vlookup function | Excel Worksheet Functions | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| Help - combine OR and AND in IF function | Excel Worksheet Functions | |||
| how do i combine IF and OR function | Excel Worksheet Functions | |||
Threaded Mode
