C
carrie08
Can someone please tell me how to enter a mixed cell refrence? I'll trying to
calculate a monthly payment schedule based on the years and loan amount.
These cells would be D9 and C10. I'm guessing it has to also be entered with
the same infor in cell D10 where the =pmt (rate, nper, pv) are. My formula is
=-PMT($E5/$E6, $e6*10, 200000). When I put mixed reference(D$9,$C10), in
also, I receive an error in my formula. I have to have the absolute reference
to E5 and E6, which are the interest(6.5%) and compounded rate (12), so I
have that part right. My formula will not copy to the rest of the schedule
because of this mixed reference. Please help!!!!
calculate a monthly payment schedule based on the years and loan amount.
These cells would be D9 and C10. I'm guessing it has to also be entered with
the same infor in cell D10 where the =pmt (rate, nper, pv) are. My formula is
=-PMT($E5/$E6, $e6*10, 200000). When I put mixed reference(D$9,$C10), in
also, I receive an error in my formula. I have to have the absolute reference
to E5 and E6, which are the interest(6.5%) and compounded rate (12), so I
have that part right. My formula will not copy to the rest of the schedule
because of this mixed reference. Please help!!!!