Need to allow only for the following inputs Principal (200,000 or 210,000), Annual Interest Rate (3.9% or 6.9%), Term in Years (accepting any value from 1 to 10), and Number of Payments (Periods) per Year (accepting value of 12, 13, 24, and 26). I need data validation and to consolidate the excel file further
Solved by Z. Q. in 21 mins