| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
