wexas
asked on
Excel - VBA
Hello Experts
Can you please assist me this, i need to write user defined function on Excel where by i can allocate the join period of a member based on number months since member joined. I tried doing this on MS access query but it doesn't work.
Attached is the sample data i need to polulate column L, for example if join period is between 0-3 months then "0-3 M", if between 0-6m then "0-6 m" and so on
Excel-VBA-join-Period.xls
Can you please assist me this, i need to write user defined function on Excel where by i can allocate the join period of a member based on number months since member joined. I tried doing this on MS access query but it doesn't work.
Attached is the sample data i need to polulate column L, for example if join period is between 0-3 months then "0-3 M", if between 0-6m then "0-6 m" and so on
Excel-VBA-join-Period.xls
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
perfect answer
Thank you. I would be remiss, however, if I didn't point out that rorya's solution was just as effective and a lot more eloquent then a nested if.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
=IF(K2>12,"12+","0-"&LOOKU