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

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