newbie here
i am doing a membership list and want to be able to have a column that i can input = session week month annual as options

each option would then generate a £ value in another column ie £25 £50 etc

also a column that has a date and can change based on session week etc to either a week month hence

make sense??

any help appreciated