month text in calculation

[KUMPFfrog]

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

 

[T. Valko]

Try this:

=IF(MONTH(A1&1)>=7,A2*B2,A2*C2)

 

[Lars-Åke Aspelin]

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

 

[KUMPFfrog]

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

 

[KUMPFfrog]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!