Hey ppz?any 1 gud at IF questions?? basically i have a Date-of-birth list box with 1940,1941,1942 etc to 1995. and a label which has to show the maximum mortgage available depending on:
so the if statement would have to work it out how old they are depending on the DOB???anyone know how to write it??*Over 50yrs- maximum mortage = 15yrs
*between 40 - 50 = 20yrs
*Between 30 - 40 = 25
*betwen 18 - 30 = 30yrs
*Under 18yrs - NO mortgage