+ Reply to Thread
Results 1 to 14 of 14

If with multiple arguments

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Winnipeg, MB
    MS-Off Ver
    Windows 7
    Posts
    52

    If with multiple arguments

    Hi,

    I need help with the formula for cell C1

    the scenario is

    If A1 is <60 then reduced B1 date to 10weeks
    IF A1 IS =60 Then reduced B1 date to 6weeks


    Thanks in advance!

    goya

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: If with multiple arguments

    Please Login or Register  to view this content.
    Like that?
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2202
    Posts
    1,468

    Re: If with multiple arguments

    deleted comment
    Last edited by dosydos; 12-10-2015 at 03:06 PM. Reason: answer already posted

  4. #4
    Registered User
    Join Date
    12-09-2015
    Location
    Winnipeg, MB
    MS-Off Ver
    Windows 7
    Posts
    52

    Re: If with multiple arguments

    Hello,

    Below is the data and I want the result in the last column.
    TYPE LE DATES LE DATE TO FP
    MD60 22-Jun-15 4-Jan-15
    MD30 22-Jun-15 7-Dec-14

    Thanks,
    anabelle

  5. #5
    Registered User
    Join Date
    12-09-2015
    Location
    Winnipeg, MB
    MS-Off Ver
    Windows 7
    Posts
    52

    Re: If with multiple arguments

    Hi,

    What I'm trying to get is to have a date on cell C1 depends on the data available on A1 and B1.

    for example:

    if A1 is =MD60 and B1=22/Jun/2015 then C2 should be 4/Jan/2015 (which is 6 weeks before the date on B1)
    if A1 is =MD30 and B1=22/Jun/2015 then C2 should be 7/Dec/2014 (which is 10 weeks before the date on B1)

    Thanks in advance,
    goya

  6. #6
    Registered User
    Join Date
    12-08-2015
    Location
    Ottawa
    MS-Off Ver
    2010
    Posts
    25

    Re: If with multiple arguments

    Assuming 1 Week has 7 days, and column B is in Date format.
    =if(A1="MD60",B1-7*6,if(A1="MD30",B1-7*10,""),"")

  7. #7
    Registered User
    Join Date
    12-09-2015
    Location
    Winnipeg, MB
    MS-Off Ver
    Windows 7
    Posts
    52

    Re: If with multiple arguments

    Hi,

    It did not work...it says I've entered too many arguments.
    What is A1 is just 60 & 30 not MD60 and MD30.

    thanks,
    anabelle

  8. #8
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2202
    Posts
    1,468

    Re: If with multiple arguments

    try this out.
    If you are using MD60 and MD30 then this equation
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    will work.
    Attached Files Attached Files
    Last edited by dosydos; 12-10-2015 at 03:45 PM. Reason: becoming more descriptive for FDibbins

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If with multiple arguments

    Quote Originally Posted by goya View Post
    Hi,

    It did not work...it says I've entered too many arguments.
    What is A1 is just 60 & 30 not MD60 and MD30.

    thanks,
    anabelle
    Your post #5 says that is what is A1?

    If you only have 30 or 60 in the cell, then adjust Imotkat's formula based on that...
    =if(A1=60,B1-7*6,if(A1=30,B1-7*10,""),"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  10. #10
    Registered User
    Join Date
    12-09-2015
    Location
    Winnipeg, MB
    MS-Off Ver
    Windows 7
    Posts
    52

    Re: If with multiple arguments

    Hi,

    It's now working... thank you so much to all of you the help.

    FDibbins...my bad I've entered the wrong cell your formula is good.
    dosydos...thanks your is good too.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If with multiple arguments

    Glad we got you where you wanted to be

  12. #12
    Registered User
    Join Date
    12-08-2015
    Location
    Ottawa
    MS-Off Ver
    2010
    Posts
    25

    Re: If with multiple arguments

    FDibbins taking credit for my work again
    Just kidding, glad we could help Goya

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If with multiple arguments

    Quote Originally Posted by ImokatExcel View Post
    FDibbins taking credit for my work again
    Just kidding, glad we could help Goya
    haha nope, was just showing how to adjust yours to work

  14. #14
    Registered User
    Join Date
    12-09-2015
    Location
    Winnipeg, MB
    MS-Off Ver
    Windows 7
    Posts
    52

    Re: If with multiple arguments

    oh sorry...you all help me. Thanks :-)

+ 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. Help with multiple arguments
    By philwaters in forum Excel General
    Replies: 3
    Last Post: 11-07-2015, 05:21 PM
  2. Multiple IF arguments
    By KateMaz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-30-2014, 09:56 AM
  3. Using multiple arguments
    By Robotacha2010 in forum Excel General
    Replies: 3
    Last Post: 06-21-2011, 04:17 PM
  4. Multiple IF Arguments
    By Chris-TT in forum Excel General
    Replies: 6
    Last Post: 12-31-2010, 01:35 PM
  5. Multiple Arguments in IF
    By Andrew.Trevayne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2010, 03:59 AM
  6. If then for multiple arguments
    By dwest100 in forum Excel General
    Replies: 1
    Last Post: 09-07-2010, 10:10 PM
  7. Multiple Arguments
    By dansargeant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2006, 04:10 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