+ Reply to Thread
Results 1 to 2 of 2

Multiple =If(and(.....)) function in one cell

Hybrid View

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    1

    Multiple =If(and(.....)) function in one cell

    Hi,
    I am trying to create an automated spreadsheet that will look at several conditions in one cell based on a drop down menu in a different row that is comparing information in a different sheet.
    I was able to do this type of an equation only using the IF function, for a simpler automation in the same sheet.
    So here is what I am trying to accomplish in more detail:

    The function looks at the calculated elapsed years in a different cell. It takes that information and determines whether or not the time is less than or more than a certain amount, then it also has to look at what is displayed in the specific cell that is referenced in sheet 1 (named "database")(same excel book.) Based on that information it gives me a reading weather the issue is "Time barred" or "To be determined."
    My problem comes up when I try to enter multiple equations like it in one cell, where it has to calculate a different elapsed years and look at a different cell in sheet 1 to determine what it says.
    My equation so far is: =IF(AND(H3>=1,AND(A5=Database!$A$5)),("Issue is time barred"),("Analysis to be Determined")) If I have this alone it works, but when I try to add more formulas to the same cell and change out where H3>=n and A5=Database$x$n; then the equation stops working.

    Basic breakdown of the formula that works:

    H3 is cell where calculation for elapsed years occurs (that cell alone has a basic calculation)
    1 refers to allowed years for warranty (the number changes based on the warranty for that object)
    A5 is the cell where the drop down menu occurs and phrasing (wording) is selected based on the information in sheet one-labeled database
    Database-is the main category that is used for reference only (does not contain any formulas) for the master sheet (where all the equations take place and the area of my concern)
    $A$5 is the cell number that contains the text that is referenced in the sheet 1 or "database"

    If anyone can help me out how to input more than one of these equations into a single cell that would be very much appreciated.
    (I need 60 of these type of calculations per cell-that's my dilemma)

    Thank you in advance for your time and for your help.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Multiple =If(and(.....)) function in one cell

    You can certainly combine multiple equations into a single cell but 60 is pushing it. Sounds like what you want to achieve, you can do with INDEX or LOOKUPS but hard to tell. Can you upload an example of how your data is laid out and what you expect to achieve (without confidential data)? (Go Advanced> Manage Attachment) to load a spreadsheet.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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