| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Functions
What type of folmula would respond to the following conditions: IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555 IF Any Cell in Column AA= A2 and Any Cell Column AB =B1 then C1=666 IF Any Cell in Column AA= A1 and Any Cell in Column AB =B2 then C1=444 IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=777 help me please? Alex |
|
#2
|
|||
|
|||
|
Try...
=IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B1),555,IF(COU NTIF(AA:AA,A2)*COUNTIF( AB:AB,B1),666,IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B 2),444,IF(COUNTIF(AA:AA ,A2)*COUNTIF(AB:AB,B2),777,"")))) Hope this helps! In article , "ALex" wrote: What type of folmula would respond to the following conditions: IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555 IF Any Cell in Column AA= A2 and Any Cell Column AB =B1 then C1=666 IF Any Cell in Column AA= A1 and Any Cell in Column AB =B2 then C1=444 IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=777 help me please? Alex |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
| PivotTable canned functions | Excel Discussion (Misc queries) | |||
| How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions | |||
| Where can I see VBA code for financial functions? | Excel Worksheet Functions | |||
Linear Mode
