month text in calculation

  • Thread starter Thread starter KUMPFfrog
  • Start date Start date
K

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
 
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
Click to expand...


Try this formula in E2:

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

Hope this helps / Lars-Åke
 
Back
Top