• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Calculation of # of months between end of year and a given inputted date

    Luke, I am only concerned about the whole months. However, If someone inputs a date that would result in less than 3 months, I want the number to be a minimum of 3 months. What modifications would need to be made to your current formula? Thanks,
  2. L

    Calculation of # of months between end of year and a given inputted date

    I am trying to come up with the formula where by excel can figure the # of months between the end of this current year (12/31/12) and a given inputted date by a customer. Any suggestions would be greatly appreicated. Thanks!
  3. L

    Proper Formula for Multiple IF statements within a range

    Thanks for your help as I seperated the amount financed ranges into different columns as #'s and then revised the formula accordingly to what you said and it worked. THANKS again!!
  4. L

    Proper Formula for Multiple IF statements within a range

    Prasad, Here is my table I am using with Column F being the amount financed and Column G being the Spread over Prime. Cell C8 is where the customer inputs the finance amount. Column 7 is where the Spread over Prime %'s are. Amount Financed Spread Over Prime $ 10,000 - 74,999...
  5. L

    Proper Formula for Multiple IF statements within a range

    I am trying to create a spreadsheet for customers to quote finance payments. I have predefined the spread over prime for these variable rate loans based upon the amount financed. Thus, for finance amounts of $10,000 - 74,999 the spread is 3.99%, $75,000 - 149,999 the spread is 3.69%, $150,000 -...
Back
Top