| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining AND, MID, and OR
I have a formula that works fine, written as:
=IF(AND(MAX(Q10:R10)=1,MID(A10,1,3)="ARU"),2,MAX(Q 10:R10)) My problem, though, is that I want to check cell A10 for other possibilities besides"ARU". Let's say I also want to check for "CON" and "TUF". How do I add these other possibilites to the formula? The OR function has thrown me for a loop! Thanks, Brendan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining second row to first row | Excel Discussion (Misc queries) | |||
| Combining | Charts and Charting in Excel | |||
| Combining look up and last? | Excel Discussion (Misc queries) | |||
| Combining Sum, IF and AND | Excel Discussion (Misc queries) | |||
| combining IF and AND | Excel Discussion (Misc queries) | |||
Threaded Mode
