| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare date and perfom calculation
I have 4 columns of data. Column 1 is "daily", Column 2 is the daily value,
Column 3 is "monthly", column 4 is the monthly factor. Example: 01/01/2009 300 01/2009 0.30 01/02/2009 240 02/2009 0.20 .... ... 03/2009 0.45 02/01/2009 340 ... ... 03/01/2009 450 I need help with a formula that checks the "Month" and "year" in column 1 and 3. If true then multiply column 2 and 3. All of Jan/09 days will be multiplied by .30, all of Feb/09 will be multiplied by .20, ..... Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare date and perfom calculation
Use this in E (assuming Col C is TEXT in the format mm/yyyy
=VLOOKUP(TEXT(A1,"mm/yyyy"),C:D,2,FALSE)*B1 and copy down "Mona" wrote: I have 4 columns of data. Column 1 is "daily", Column 2 is the daily value, Column 3 is "monthly", column 4 is the monthly factor. Example: 01/01/2009 300 01/2009 0.30 01/02/2009 240 02/2009 0.20 ... ... 03/2009 0.45 02/01/2009 340 .. ... 03/01/2009 450 I need help with a formula that checks the "Month" and "year" in column 1 and 3. If true then multiply column 2 and 3. All of Jan/09 days will be multiplied by .30, all of Feb/09 will be multiplied by .20, ..... Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare date and perfom calculation
thank you. I adjusted the monthly date to be text mm/yyyy and works great!
"Sheeloo" wrote: Use this in E (assuming Col C is TEXT in the format mm/yyyy =VLOOKUP(TEXT(A1,"mm/yyyy"),C:D,2,FALSE)*B1 and copy down "Mona" wrote: I have 4 columns of data. Column 1 is "daily", Column 2 is the daily value, Column 3 is "monthly", column 4 is the monthly factor. Example: 01/01/2009 300 01/2009 0.30 01/02/2009 240 02/2009 0.20 ... ... 03/2009 0.45 02/01/2009 340 .. ... 03/01/2009 450 I need help with a formula that checks the "Month" and "year" in column 1 and 3. If true then multiply column 2 and 3. All of Jan/09 days will be multiplied by .30, all of Feb/09 will be multiplied by .20, ..... Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| compare date to various date ranges and sum value | Excel Worksheet Functions | |||
| How do I perfom a character count in a single cell in Excel? | New Users to Excel | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Hybrid Mode
