I have a organization, where members customize there own membership according to their needs and availability. I need a formula to calculate it automatically depending on what type of membership options they have selected. Any help would be appreciated as I don't have a clue where to begin.I am attaching the rates spreadsheet. Thanks very much
Gary
Hi Gary,
You could have started with an easier question. This was a pretty tough problem. See the attached for my solution.
There was a problem if a person checked the 1 Hr and 2 Hr box just below it. That didn't make sense. It was also hidden that a member couldn't RENEW for 1 or 3 month periods. That is, your lookup table had some flaws also.
To use the attached, click in the Yellow Boxes and select what you want. The price will appear in Grand Total.
Also, could you update your profile so it shows 2007 Excel as that would have made the problem easier. With 2003 (if that is what you have) I had to build indexes instead of using FindIfs functions, only available in 2007 or newer.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks