+ Reply to Thread
Results 1 to 4 of 4

Array Formulas with Multiple Range Criteria - not returning result

Hybrid View

btparkhe1920 Array Formulas with Multiple... 11-10-2020, 06:02 AM
Glenn Kennedy Re: Array Formulas with... 11-10-2020, 06:12 AM
btparkhe1920 Re: Array Formulas with... 11-12-2020, 12:33 AM
JeteMc Re: Array Formulas with... 11-14-2020, 04:41 PM
  1. #1
    Forum Contributor
    Join Date
    10-22-2020
    Location
    Bharat
    MS-Off Ver
    MS office 24
    Posts
    146

    Array Formulas with Multiple Range Criteria - not returning result

    dear all
    hi
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Array Formulas with Multiple Range Criteria - not returning result

    I think you need to provide some explanation!! I am sure the answer is not =U14 copied across and down.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Contributor
    Join Date
    10-22-2020
    Location
    Bharat
    MS-Off Ver
    MS office 24
    Posts
    146

    Re: Array Formulas with Multiple Range Criteria - not returning result

    I am checking the calculation of interest on the customer's debit balance.
    It is the purpose to check how many days he has in it, how much interest he has in that day.
    It has some parameters is below.
    1. 0 is 08 days interest nil
    2. 09 to 15 days interest 10%
    3. 16 to 60 days interest 13%
    4. 60 above 16%
    5. D2 IS- Clearing Date - Int Date
    6. D1 IS - Clearing Date - Int Date - d2 (if same bill Clearing date)
    I have given parameter of 1-3 in excel file, and also file upload
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,896

    Re: Array Formulas with Multiple Range Criteria - not returning result

    I feel that we need some more clarification on point #6 in order to be able to help (i.e. why is AC14 correct, but AC19 incorrect).
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Array Formulas with Multiple Range Criterias - not returning result
    By stearno in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-10-2020, 01:56 AM
  2. t test with multiple (2) criteria not returning expected result
    By bjmatush in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-08-2017, 12:23 PM
  3. [SOLVED] array formula to create dyanmic range returning multiple criteria
    By devi1337 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2017, 02:08 PM
  4. Countifs on an Array Range using multiple criteria in an Array
    By Mysore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2016, 04:39 PM
  5. Replies: 6
    Last Post: 10-31-2014, 02:27 PM
  6. Replies: 5
    Last Post: 06-14-2006, 07:10 AM
  7. Creating Array formulas with multiple criteria
    By Space Elf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2006, 09:30 AM

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