ComeçarComece de graça

Validating payments

After completing the validation for VINs, APR, and the number of installments, your next step is to finalize the car loan calculator by applying the correct validation rules for:

  • Down Payment – Ensure the value is reasonable and aligns with the loan terms.
  • Final Payment – Validate this to ensure consistency with the total loan amount and installment plan.
  • Date of First Payment – Ensure the date is in a valid format and follows logical constraints (e.g., must be a future date).

Next steps:

  • Continue working on the same sheet where you performed the previous validations.
  • If you lost progress or need a reference, open the file: 2_2_validating_payments.xlsx.
  • Once completed, the loan calculator should prevent incorrect entries and ensure accurate financial calculations.

Este exercício faz parte do curso

Data Validation in Excel

Ver curso

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício