+ Reply to Thread
Results 1 to 8 of 8

Multiple IF in one cell

  1. #1
    Registered User
    Join Date
    11-08-2008
    Location
    Montreal
    Posts
    57

    Multiple IF in one cell

    Hello, Please if someone can help me with multiple IF formula,

    I am preparing a sheet which has U.S and Canadian cost price what I would like is on E7 to calculate jobber price from my cost on "F" based on
    value from Q3,Q4,Q5 then add the exchange rate P3 and calculate the Margin of profit based and O3,O4,O5

    And same time E7 must also check "G" and if there is a value should calculate same way as above except not to add the exchange rate P3.

    I know this is not making any sense that's why I have attached a sample of what I needed. I hope that helps.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: Multiple IF in one cell

    ???

    In E7, copied down:

    =IF(SUM(F7:G7)=0,"",LOOKUP(SUM(F7:G7),$Q$3:$Q$5,$O$3:$O$5)*SUM(F7:G7)*IF(F7>0,P3,1))

    Also, please amend your profile to show which version of Excel you are using. Are you really still using Excel 2003 or earlier??? If not, why are you using the obsolete .xls format?
    Attached Files Attached Files
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: Multiple IF in one cell

    Just noticed an error:

    =IF(SUM(F7:G7)=0,"",LOOKUP(SUM(F7:G7),$Q$3:$Q$5,$O$3:$O$5)*SUM(F7:G7)*IF(F7>0,$P$3,1))
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-08-2008
    Location
    Montreal
    Posts
    57

    Re: Multiple IF in one cell

    Thank you for your fast reply, at work we use 365, and at home 2016, but sorry somehow it just saved as .xls

  5. #5
    Registered User
    Join Date
    11-08-2008
    Location
    Montreal
    Posts
    57

    Re: Multiple IF in one cell

    Thank you thank you this is what I wanted, just one small problem can we add to this another value from $1001.00 and on rate 1.10


    Please

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: Multiple IF in one cell

    Is this it??

    if so... You're welcome. If not, what's wrong & I'll fix it (with a bit of luck!!).



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-08-2008
    Location
    Montreal
    Posts
    57

    Re: Multiple IF in one cell

    Thank you very much its what I needed,

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: Multiple IF in one cell

    You're welcome and thanks for the Rep.

+ 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