Forum Discussion
Change the years to calculate a loan
- DeletedDec 19, 2017
The If Statement goes like this
If(condition, value if true, value if false)
Your formula syntax needs to be fixed
=if(e22="","" ,PMT(H22/52,$L$22*52,-E22,0), 0)
-You have a premature closing bracket for the if statement (removed)
-You don't have a value if the condition is false. I assumed you want a zero, but you might want something else.
-I don't know if your condition works since you haven't told us anything about e22.
The If Statement goes like this
If(condition, value if true, value if false)
Your formula syntax needs to be fixed
=if(e22="","" ,PMT(H22/52,$L$22*52,-E22,0), 0)
-You have a premature closing bracket for the if statement (removed)
-You don't have a value if the condition is false. I assumed you want a zero, but you might want something else.
-I don't know if your condition works since you haven't told us anything about e22.