I think it might be easier to have you make the loan fee cell changed by the user, and then make the calculation in the cell below the loan amount. That way the user can enter 1/2 point, 1 point, etc. without having to enter a formula from the loan amount above. Also, if they make the changes just to the loan fee % cell, they can enter a zero, and your calculated cells will follow with zeros.
I appreciate the suggestion and I think it makes sense to implement. I’ve added it to my change request list for inclusion in an upcoming version of the model.
