I'm working on returning a monthly prepaid value if the membership has not ended and the month is current or passed. I.E. a membership started in November of 2014 will go until November of 2015 and as each month comes return the monthly fee to determine the prepaid used and remaining. The area I am trying nested ifs is in the yellow/orange area starting in columns BI. At this time I do not need to determine prorated amount for partial months.
Any help would be appreciated.
"used (paid?)" & "remaining, is that the remainder of the prepaid, or the remainder of the yearly dues?"
Where are these amounts entered?
Last edited by protonLeah; 02-07-2015 at 05:52 PM.
Ben Van Johnson
Eventually to the summary tab. What I want to do first is have the month fees populate in the orange/yellow area so I can pull those numbers into the blue section and the summary tab. I did not include the summary tab on the sample file
Still don't quite understand but does this help:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks