Results 1 to 9 of 9

Problem with Cummulative IFs

Threaded View

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    London, England
    MS-Off Ver
    2015
    Posts
    5

    Question Problem with Cummulative IFs

    Dear all,

    I'm struggling with a function to connect a set of IFs in excel for a 3-dimensions table. Hope you can help me!!!

    I'm basically writing a calculator for my car financing business where depending on the customer location (Spain, Portugal or Italy), and the value of his car, he will pay X, Y or Z interest rate. So, first you select the customer location, and input the car value deposited. The assets below 5k will pay 0.3%, between 5k-10k will pay 0.2% and above 10k will pay 0.1%. The thing is that those are cumulative, so if you deposit a car valued in 8k, the first 5k pay 0.3% and the rest 3k pays 0.2%.

    Please HELP! I attached the file for further clarification
    Attached Files Attached Files
    Last edited by polez131059; 05-12-2020 at 03:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cummulative totals
    By HarleyRider in forum Excel General
    Replies: 8
    Last Post: 10-05-2018, 05:35 PM
  2. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  3. Excel problem - urgent
    By infodata in forum Excel General
    Replies: 1
    Last Post: 05-12-2006, 11:50 AM
  4. Urgent problem needs help in solving
    By copu2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2006, 03:15 PM
  5. cummulative sum
    By chiapas77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2006, 02:50 PM
  6. Urgent problem with Vllookup
    By Jeff in forum Excel General
    Replies: 2
    Last Post: 09-22-2005, 03:05 PM
  7. [SOLVED] VLookup problem...help pls...urgent
    By sand in forum Excel General
    Replies: 0
    Last Post: 06-27-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1