+ Reply to Thread
Results 1 to 7 of 7

Need 3 "IF" in one formula

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Need 3 "IF" in one formula

    Attached is a file. This is what i have going so far....

    O2 formula is correct

    O11 Needs to have an "IF" added to add IF (J11) = gal

    O8 - Needs to have an "IF" added to the formula to account for IF (J8) = 100/gal


    Then after the above 2 formulas are fixed it need to combined them all so that the same formula is in all cells in Column O

    Can you have 3 "IF" formulas in 1 formula???
    Attached Files Attached Files
    Last edited by Jsimpson19; 12-11-2013 at 06:47 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,805

    Re: Need 3 "IF" in one formula

    yes you can a few IF statements nested

    this is the main formula
    =IF(J2=M2,H2*N2/L2,(H2*43.56)*N2/L2)

    now what do you want to with the other IFs

    O8
    =SUM(N8/K8)*((H8/100)*K8)

    what do you need to do for 100/gal

    O11
    =SUM(N11/K11)*(H11*K11)

    =IF( J2= "1000/sqft" , IF(J2=M2,H2*N2/L2,(H2*43.56)*N2/L2) , IF( J2= "GAL", SUM(N8/K8)*((H8/100)*K8), etc etc

    is that the sort of thing you wanted to do ?
    have a IF based on thw contents of J2 and depending on content carry out different calculations ?
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Need 3 "IF" in one formula

    almost

    So i need to base everything off of Column (J) and column (N)

    IF 1000/sqft is in both columns i need this formula... H2*N2/L2
    IF acre is in both columns i need this formula... H2*N2/L2
    IF 1000/sqft is in Column (J) and acre in column (N) i need this formula.... (H2*43.56)*N2/L2
    IF 100/gal is in Column (J) i need this formula... =SUM(N8/K8)*((H8/100)*K8)
    IF gal is in Column (J) i need this formula.... =SUM(N11/K11)*(H11*K11)

    But i am running into the issue have all this together into one formula to drag down the entire column of (O) and calculate correctly

    Thank you again in advance for any help you may provide

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,252

    Re: Need 3 "IF" in one formula

    Long Formula with nested IF function, just check the file

    Azumi
    Attached Files Attached Files

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Need 3 "IF" in one formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,805

    Re: Need 3 "IF" in one formula

    Thanks for providing the exact details, and I see @vlady has provided the If statement , so hopefully that now solves you request

  7. #7
    Registered User
    Join Date
    03-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Need 3 "IF" in one formula

    thanks so much for your help

+ 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. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  2. [SOLVED] How to short my formula which is ="("&a1&","&a2&","&a3&","&a4&" end in "&a200&")
    By vengatvj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-07-2013, 07:49 PM
  3. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 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