+ Reply to Thread
Results 1 to 3 of 3

Any way to create and if statement that involves two inputs?

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2007
    Posts
    2

    Any way to create and if statement that involves two inputs?

    I'm working on a schedule that would output a number based on 1) which quarter amortization begins and 2) the number of months in the amortization period. Here's an excerpt of my data and what I have so far:

    A1 = quarter drop down
    A2= month drop down

    27 mo 30 mo 33 mo
    Q1 222 245 270
    Q2 230 255 278
    Q3 222 252 277
    Q4 223 245 275

    example (for 27 mo): =if(A1=A5,B5,if(A1=A6,B6,if(A1=A7,B7,if(A1=A8,B8))))
    (for 30 mo): =if(A1=A5,C5,if(A1=A6,C6,if(A1=A7,C7,if(A1=A8,C8))))

    The problem is that the formula only takes into account the quarter selection; a different formula needs to be used depending on the armotization period, so the schedule cannot easily be updated. I need it to take into account the amortization period (i.e. 27, 30, 33) without having to select a different formula (be able to select a different amortization period and have the schedule automatically update). So we need an "if and if" statement. (If A1=Q1 and B1=27, then 222 for instance). Is this possible? Any ideas?
    Last edited by excelerator84; 08-24-2012 at 02:38 PM.

  2. #2
    Registered User
    Join Date
    08-09-2012
    Location
    Hayes, VA
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Any way to create and if statement that involves two inputs?

    I don't completely understand your table, but the last statement (if A1=Q1 AND B1=27 then 222) would be:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope that helps a little. An OR statement is done the same way.

  3. #3
    Registered User
    Join Date
    08-24-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Any way to create and if statement that involves two inputs?

    That works; I just have to do a lot of nested strings with that formula to incorporate all of the options. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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