+ Reply to Thread
Results 1 to 2 of 2

Nested IF formula help

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    20

    Nested IF formula help

    Dears,
    I need to prepare aging report. there are four ages i.e. 30,60,90 and 90+ days.
    I want excel to check if the total PAST DUES was less than or equal to March billed amount, then it should be age (30), and if the sum of March and Feb billed amount was less than or equal Past dues then it should be in age 60, and if the sum of Feb, Jan and Dec are equal or less than Past dues then it should be age 90 and if the amount of Past dues was more than or equal to billed amount of March, Feb, Jan and Dec then it should be counted as 90+.
    currently I'm able to make the formula in different cells but there will be some accounts in two or more than two ages. therefore need your support. thanks
    Aging IF.PNG

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Nested IF formula help

    something like that: =IF(F2<=E2,30,IF(SUM(D2:E2)<=F2,60,IF(SUM(B2:D2)<=F2,90,IF(SUM(B2:E2)<=F2,"90+","")))) ?

    btw.
    for OMD
    Past dues > March
    Past dues < March + Feb
    Past dues < Dec + Jan + Feb
    Past dues < Dec + Jan + Feb + March
    formula desn't meet these conditions so result is FALSE (I used "" in formula to show nothing)
    Last edited by sandy666; 04-25-2017 at 01:29 AM.

+ 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. nested formula help?
    By nimv1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2016, 05:35 PM
  2. Replies: 2
    Last Post: 08-24-2014, 04:56 AM
  3. [SOLVED] Help with a Nested Formula
    By ISI_Med in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2014, 01:28 PM
  4. [SOLVED] Nested If Formula
    By sek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-19-2012, 10:44 AM
  5. Replies: 2
    Last Post: 10-08-2009, 09:51 PM
  6. help on a nested countif/nested if formula
    By vickiemc in forum Excel General
    Replies: 2
    Last Post: 08-13-2008, 08:29 AM
  7. nested formula
    By jvanderveen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2007, 10:21 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