| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need this IF function to add if any value that it examines is the
I set up this if function in a cell and it reads in a worksheet the different
cost codes I input, in all the "12" cells and matched them into another worksheet were it brings the values that are in the "41" cells....but I can't figure out how to add the results if in the "12" cells are two or three up to seven of the cost codes....thanks for the help. =IF(A4='Foreman''s DTC(1)'!$D$12,'Foreman''s DTC(1)'!$E$41,IF(A4='Foreman''s DTC(1)'!$F$12,'Foreman''s DTC(1)'!$G$41,IF(A4='Foreman''s DTC(1)'!$H$12,'Foreman''s DTC(1)'!$I$41,IF(A4='Foreman''s DTC(1)'!$J$12,'Foreman''s DTC(1)'!$K$41,IF(A4='Foreman''s DTC(1)'!$L$12,'Foreman''s DTC(1)'!$M$41,IF(A4='Foreman''s DTC(1)'!$N$12,'Foreman''s DTC(1)'!$O$41,IF(A4='Foreman''s DTC(1)'!$P$12,'Foreman''s DTC(1)'!$Q$41,"0"))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
