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

month text in calculation
 

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

"T. Valko" wrote:

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

month text in calculation
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"KUMPFfrog" wrote in message
...
Thank you, Thank you, Thank you.
both solutions worked great!!!!

"T. Valko" wrote:

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