Excel @choose function

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

For those of us in the financial field, who compile 31
day journals, it is unfortunate that the @choose function
only works for numbers 1-29.

Has anyone created a conditinal fomula, which addresses
this shortcoming.?

Thanks,

marty
 
Marty said:
For those of us in the financial field, who compile 31
day journals, it is unfortunate that the @choose function
only works for numbers 1-29.

Has anyone created a conditinal fomula, which addresses
this shortcoming.?

Thanks,

marty
Click to expand...

Best to seek advice on this via the Excel newsgroups...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Trying to randomly choose a number from a set list of numbers 8
How do I get Excel to display which financial year a date is in? 6
Excel How to enable engineering functions in MS Excel 2000? 3
Limit of choose function up to 29 index no. 3
Choose function in Excel 2003 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Correct Source Information for Bibliography 3

Back
Top