Excel will not allow a 12 element IF statement...........use the VLOOKUP
feature.........put all of the month numbers in a column out of the way (X)
and in the column to the right of it(Y), put the corresponding formulas you
wish to invoke,
then use
=VLOOKUP(B2,X:Y,2,FALSE)

Vaya con Dios,
Chuck, CABGx3




"Bunnybabe" wrote in message
...
I'm trying to create a formula, where

If a cell = a month, then depending on which month there will be a
calculation.
This is as far as I got and it's wrong
eg.

=if(B2="January",1*2.083)*OR(b2="February",2*2.083 )*OR(b2="March",3*2.083)*O
R(b2="April",4*2.083)...........I need this for 12 months
I can only get a formula that does the first part, and nothing else.
HELP ME PLEASE!!!!