Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting Multiple Results
I have a worksheet in which the user enter's a lowercase "x" in the L column
if they wish to calculate the Labor cost and/or a lowercase "x" in the M column if they wish to calculate the Material cost and/or a lowercase "x" in the E column if they wish to calculate the Equipment cost and/or a lowercase "x" in the O column if they wish to calculate the Other cost. In most cases, the end user will be calculating costs for more than just Labor or Material. In some cases, the end user will be calculating the cost of all four classifications; Labor, Material, Equipment and Other. Once the lowercase "x" is entered into the appropriate cell, Excel will make a calculation by multiplying an inputted quantity x cost per quantity unit for materials and equipment. If labor is to be calculated it would be Quantity x Labor Hours per Quantity x Labor Rate in Dollars. If I cannot find a function or custom function to perform this function, I have to added a sum column for each of the four types of costs per task line item. With the lowercase "X" feature, I only need one sum column. Any help would be appreciated. Thank You, JAD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting Multiple Results
maybe you can adjust this example to your needs =IF(L1="x",A1*B1)+IF(M1="x",A2*B2)+IF(N1="x",A3*B3 )+IF(O1="x",A4*B4) you can also multiply the nested if's if you need to -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=562709 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting Multiple Results
Adjust as required:
=(L1="x")*A1*B1+(M1="x")*A2*B2+(N1="x")*A3*B3+(O1= "x")*A4*B4 HTH "davesexcel" wrote: maybe you can adjust this example to your needs =IF(L1="x",A1*B1)+IF(M1="x",A2*B2)+IF(N1="x",A3*B3 )+IF(O1="x",A4*B4) you can also multiply the nested if's if you need to -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=562709 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting one from multiple occurrences | Excel Worksheet Functions | |||
split results to multiple worksheets | Excel Worksheet Functions | |||
selecting multiple cells with ctrl key | Charts and Charting in Excel | |||
Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
Array with multiple results | Excel Worksheet Functions |