Woodpusher147
Board Regular
- Joined
- Oct 6, 2021
- Messages
- 69
- Office Version
- 365
- Platform
- Windows
Hi All
I have a sheet that calculates credit interest and need to show an error if someone inputs wrong figures.
EG
I 21 = "loan term" J21 = "loan amount" L21 = "Loan cost" O21 = "loan cost percentage"
I have a table with the loan cost percentages for each term
6m = 4.29%
10m = 5.65%
12m=5.91%
and so on until 36m
Column I (loan term) is a dropdown of the monthly choices
Column J Loan amount is a calculation based on cost less deposit (locked cell)
Column L Loan cost is manually inputted (this is the cell that could cause an error should the person input the wrong loan amount)
Column O Calculates the percentage of loan cost like so =IFERROR(L21/J21,"")
Basically, the loan cost percentage cannot be more than 5% out either way so I need column O to divide column L by column J but return an error if the % is more than 5% away from the percentage that is assigned to the on term as in my term table.
If term chosen was 10m then column O result would show error message if it was more than 5% above or below 5.65%
Hope thats clear, not sure if it is :/
Thank you very much for any help
I have a sheet that calculates credit interest and need to show an error if someone inputs wrong figures.
EG
I 21 = "loan term" J21 = "loan amount" L21 = "Loan cost" O21 = "loan cost percentage"
I have a table with the loan cost percentages for each term
6m = 4.29%
10m = 5.65%
12m=5.91%
and so on until 36m
Column I (loan term) is a dropdown of the monthly choices
Column J Loan amount is a calculation based on cost less deposit (locked cell)
Column L Loan cost is manually inputted (this is the cell that could cause an error should the person input the wrong loan amount)
Column O Calculates the percentage of loan cost like so =IFERROR(L21/J21,"")
Basically, the loan cost percentage cannot be more than 5% out either way so I need column O to divide column L by column J but return an error if the % is more than 5% away from the percentage that is assigned to the on term as in my term table.
If term chosen was 10m then column O result would show error message if it was more than 5% above or below 5.65%
Hope thats clear, not sure if it is :/
Thank you very much for any help