#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 71
Default PMT Function

How do i figure out this "the formula must reference the input values in
cells B15 and B16. These input values will not affect the computed values in
the table when generated."

i tried that way and because i change those numbers in cells B15 and B16 the
numbers in my table changed as well.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default PMT Function

Ashley,

Pleas don't multi-post your questions. Once is enough.

From my reply to your other post:

Perhaps you need to use absolute references?
=PMT(0.09/12,$B$16*12,-$B$15)


HTH,
Bernie
MS Excel MVP


"ashley" wrote in message
...
How do i figure out this "the formula must reference the input values in
cells B15 and B16. These input values will not affect the computed values in
the table when generated."

i tried that way and because i change those numbers in cells B15 and B16 the
numbers in my table changed as well.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
Creating a Custom Excel Function to Calculate Gini Coefficients [email protected] Excel Worksheet Functions 3 February 21st 06 10:15 PM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"