Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!! |
#2
|
|||
|
|||
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!!!! |
#3
|
|||
|
|||
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!!!! |
#4
|
|||
|
|||
=match(B2,{"Jan","Feb","Mar","Apr","May","Jun","Ju l","Aug","Sep","Oct","Nov"
,"Dec"},0)*2.083 |
#5
|
|||
|
|||
=MATCH(B2,{"Jan","Feb","Mar","Apr","May","Jun","Ju l","Aug","Sep","Oct","Nov"
,"Dec"},0)*2.083 |
#6
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |