No, that's level payments. might be wrong anyway.
Hey excel wizards. Have a question.
I have a spreadsheet that I'd like to copy down the column and I want one of the variables to change (the way it usually does) but I want another variable to stay the same. Is that possible?
Here is the formula:
=(2144.63+(40*F2))/SUM(B2:C25)
I want the F2 to change to F3, F4 etc. as I copy it down the column, but I want the denominator to stay the same as it copies down (i.e. I want all the copies formulas to still have SUM(B2:C25))
replace B2:C25 with $B$2:$C$25
First $ "anchors" column B, second $ anchors row 2
if you open the formula and highlight B2:C25, hit F4, it will lock that in - then toggle to row anchored only, column anchored only, nothing anchored
Awesome, thank you!