ExcelBanter - month text in calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - month text in calculation (https://www.excelbanter.com/excel-worksheet-functions/195896-re-month-text-calculation.html)

month text in calculation

On Tue, 22 Jul 2008 14:39:01 -0700, KUMPFfrog
wrote:

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

Try this formula in E2:

=IF(MONTH(DATEVALUE(A1&" 01"))MONTH(DATEVALUE("july" & " 01")),
A2*B2, A2*C2)

Hope this helps / Lars-Åke

month text in calculation

Thank you, Thank you, Thank you.
both solutions worked great!!!!

"Lars-Ã…ke Aspelin" wrote:

On Tue, 22 Jul 2008 14:39:01 -0700, KUMPFfrog
wrote:

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

Try this formula in E2:

=IF(MONTH(DATEVALUE(A1&" 01"))MONTH(DATEVALUE("july" & " 01")),
A2*B2, A2*C2)

Hope this helps / Lars-Ã…ke