Excel Formula's
 

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)*OR(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!!!!

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!!!!

If B2 is a real date, you can simply use

=MONTH(B2)*2.083

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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!!!!

=match(B2,{"Jan","Feb","Mar","Apr","May","Jun","Ju l","Aug","Sep","Oct","Nov"
,"Dec"},0)*2.083

=MATCH(B2,{"Jan","Feb","Mar","Apr","May","Jun","Ju l","Aug","Sep","Oct","Nov"
,"Dec"},0)*2.083

If the month is text, and not a date, then perhaps another option might be:
=MONTH(DATEVALUE(A1 & 1))*2.083

However, the abbreviated spelling of a month would also work (i.e. "April"
or "Apr")
HTH
--
Dana DeLouis
Win XP & Office 2003


"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)*OR(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!!!!