Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet that looks roughly like the following:
A B C L M N O 1 Jan Feb March........... to Dec Wage Base Liability at: XXXXX 2 joe 3 7 88 ........... $100 $______ I am trying to figure out a formula for cell N2 so that if the user types a "Jan" into cell O1 they will get the product of cell A2*M2. If they type "Feb" into cell O1 they will get the product of B2*M2...and so on through to Dec. Is this possible or do I just need to do 12 "If"'s in the formula? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
product between two dates and with criteria | Excel Worksheet Functions | |||
Executing a formula based on criteria being met | Excel Worksheet Functions | |||
Product of 2 arrays based on criteria | Excel Discussion (Misc queries) | |||
conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
Need formula based on criteria. | New Users to Excel |