| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Functions
How would one include the following conditions in a folmula
IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B1 then C1=1 IF INPUT worksheet Column A= A2 and INPUT worksheet Column B =B1 then C1=2 IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B2 then C1=4 IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B3 then C1=5 etc... |
|
#2
|
|||
|
|||
|
Try again. Still don't understand.
"ALex" wrote: How would one include the following conditions in a folmula IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B1 then C1=1 IF INPUT worksheet Column A= A2 and INPUT worksheet Column B =B1 then C1=2 IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B2 then C1=4 IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B3 then C1=5 etc... |
| 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
