Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Choose function not working
Excel Masters,
I can't get my choose formula to work =A2*(CHOOSE(INDEX(MATCH(B2,period,0),1),52,26,12,2 )) Essentially doing up a home budgeting sheet that i can modify at some point. what am I trying to achieve? A2 is a payment amount B2 is a drop down list of payment frequencies ie week, fortnight, month, bi-annual. This cell has the defined name of "period" I did read on another forum that the INDEX function is not needed, however, this is how it stands at the moment. At this point, it will only calculate weekly no matter what period I choose from the drop down..... Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choose format while Find & Replace not working | Excel Discussion (Misc queries) | |||
Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
which function to choose? | Excel Worksheet Functions | |||
Which function to choose? | Excel Worksheet Functions | |||
CHOOSE Function | Excel Worksheet Functions |