| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF function
I have issues when dealing with the IF function (to sure it should be IF or
PRODUCT): A,H,J,M are text cells and C= to number cells when (H1:H1000=J1) AND (A1:A1000=M1) Then C1='1000-1' (H1:H1000=J1) AND (A1:A1000=M2) Then C1='1000-2' (H1:H1000=J1) AND (A1:A1000=M3) Then C1='1000-3' (H1:H1000=J1) AND (A1:A1000=M4) Then C1='1000-4' (H1:H1000=J2) AND (A1:A1000=M1) Then C1='2000-1' (H1:H1000=J2) AND (A1:A1000=M2) Then C1='2000-2' (H1:H1000=J2) AND (A1:A1000=M3) Then C1='2000-3' (H1:H1000=J2) AND (A1:A1000=M4) Then C1='2000-4' (H1:H1000=J3) AND (A1:A1000=M1) Then C1='3000-1' (H1:H1000=J3) AND (A1:A1000=M2) Then C1='3000-2' (H1:H1000=J3) AND (A1:A1000=M3) Then C1='3000-3' (H1:H1000=J3) AND (A1:A1000=M4) Then C1='3000-4' help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Threaded Mode
