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