Question: Write a user-defined function that calculates the average collection period with two arguments: accounts receivable and annual credit sales, and assumes that there are 360
Now, write another version of the function that accepts an optional third argument that indicates whether to use 360 or 365 days in a year. This third argument should default to using a 360-day year. The second function should return an error value (look up CVErr in the help) if the user specifies any number other than 360 or 365 days per year.
Step by Step Solution
3.42 Rating (174 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat 00... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
624-B-A-F-A (2221).xlsx
300 KBs Excel File
