the formula I have used to date is
=LOOKUP(I3,{0,25,250},{"1 Jan 2014","1 Jan 2014","Never"})
What this has done for me is that when I enter $25 in I5 the formula would enter the expire date of 1 Jan 2014 and that was ok until we changed our membership expire dates.
Now a member can sign up say... on March 1, 2014 for 25 dollars but I cannot figure out the formula to expire one year hence considering for instance that if we have 12 members who all sign up on different months how would you write a formula to change individually each sign up dates based on the amount (0,25,250) in I5.
I have an excel database I can attach if that might help to clarify
Thanks for this
Bookmarks