| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
month text in calculation
Try this:
=IF(MONTH(A1&1)=7,A2*B2,A2*C2) -- Biff Microsoft Excel MVP "KUMPFfrog" wrote in message ... I have a drop down list in 'A1' with all the months spelled out. I want to use the selcted value, of that cell, in a formula. A1="august" in 'E2, i want to perform an IF function. If A1 is or = july, return A2*B2, if not return A2*C2. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month Calculation | Excel Worksheet Functions | |||
| Help!!! End of Month Calculation | Excel Worksheet Functions | |||
| Last Day Of Month Calculation... | Excel Worksheet Functions | |||
| Month end calculation | Excel Discussion (Misc queries) | |||
| month-to-month calculation | Excel Discussion (Misc queries) | |||
Threaded Mode
