Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm looking for a function which will do the following:
(1) Check each cell in "Sheet1", column "J" for a value of 8, 10, or 12.5 Example: If cell "J5" on "Sheet1" = 8, then add the value of "Sheet1" cell "I5" to "Sheet2" cell "B17", etc. (2) If the value is 8, then add the value of the neighboring cell in column "I" to cell "B17" in "Sheet 2" (3) If the value is 10, then add the value of the neighboring cell in column "I" to cell "B18" in "Sheet 2" (4) If the value is 12.5, then add the value of the neighboring cell in column "I" to cell "B19" in "Sheet 2" Any help appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
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 |