Excel Formula's

B

Bunnybabe

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

CLR

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 said:
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.
Click to expand...
=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
 
B

Bob Phillips

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 said:
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.
Click to expand...
=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
 
º

º¼ÖÝÈË

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

º¼ÖÝÈË

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

Dana DeLouis

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
 
Top