| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula that recognize
here is the sample of my formula, this is what im tryin to say =IF(A1=PMC
1234,C1+120,"",IF(A1=PLB 1234,C1+60,""). this is the prob, PMC or PLB is not constant, it is always followed by different numbers, if i use PMC, it is plus 120, if PLB, it is plus 60.. im tryin to replace it with asterisk, therefore =IF(A1=PMC*,C1+120,"",IF(A1=PLB*,C1+60,""). but it doesnt work... i hope someone understand my problem... thanks rynner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Formula - Won't Recognize Dates | Excel Discussion (Misc queries) | |||
| cells don't recognize formula | Excel Worksheet Functions | |||
| recognize formula | Excel Worksheet Functions | |||
| Formula to recognize text only in a cell | Excel Worksheet Functions | |||
| Formula to recognize Duplicates | Excel Worksheet Functions | |||
Threaded Mode
