| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
array using contains
I have a formula below that calculates raw materials needed. My problem is
that now we have started receiving orders in pairs and eaches and all come into my sytem as one or the other (ex it will say 2 EA or 2 PR). When I export them into my spreadsheet I need to be able to double my need calculated by the formula below. The only thing I have in my spreadsheet to distinguish is a description which contains 2PK. Could you tell me how to rewrite this formula to say if cell C3 contains "2PK" in the description then multiply the E3 qty by 2? E3 represents the units on order. =IF(K3+L3-E3+F3<0,K3+L3-E3+F3,"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
| Array: Counting multiple values within array | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Threaded Mode
