Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Multiple Formulas in same Cell

  1. #11
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,675
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    If I follow, try:

    Code:
    =IF(A2<40,0,A2-40)
    You'd have got a quicker response opening a new thread though.

    Matty

  2. #12
    New Member
    Join Date
    Mar 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    Dear,
    I have faced a problem that, I make a invoice in five parts If i mark in description cell automatic show Sr NO Rate but Rate Cell is Show "False". But i want to stop if Description is no product name/marked Rate Cell would show Blank " "
    Have any solution for me
    SR NO DESCRIPTION Rate Quantity AMOUNT
    1
    2 Chicken Spicy Wings(500Gm) 210 5 1050
    3 Chicken Nuggets (1000Gm) 315 5 1575
    4 Chicken Nuggets (1000Gm) 315 5 1575
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0
    FALSE 0

  3. #13
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,675
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    Welcome to MrExcel.

    Although you have a similar problem to the one mentioned in this thread, it's always best to start a new thread rather than adding your question to an old one. That said, it sounds as though you need to wrap your existing formula within the IF function. Something like:

    Code:
    =IF(A2="","",YourExistingFormulaHere)
    Where A2 contains the SR Number.

    Matty

  4. #14
    New Member
    Join Date
    Aug 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    Quote Originally Posted by Anne Troy View Post
    Multiple CONDITIONS, yes. Multiple formulas, no.

    For instance:

    =IF(OR(A1>0,A1<25),"Yes","No")

    will return Yes if A1 is between zero and 25, and No if it is zero or less than zero, or greater than 25.

    How would you apply this same principle to return text based on TODAY date cell - i.e. if 2 weeks before TODAY return "xxx" and today/future date return "xxx" and if older than 2 weeks return "xxx"? Thanks

  5. #15
    New Member
    Join Date
    Feb 2017
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    I have multiple cells which have formulas in below

    Cell

    AW - =DAY(DATE(YEAR(L2),MONTH(L2)+1,0))
    AX- =DATE(YEAR(L2),MONTH(L2)+1,0)-L2+1
    AY - =EOMONTH(L2,0)
    AZ - =DAY(DATE(YEAR(M2),MONTH(M2)+1,0))
    BA - =EOMONTH(M2,0)
    BB - =BA2-M2
    BC - =AZ2-BB2
    BD - =IF(BB2= 0,0,X2/AZ2*BC2)
    BE - =DATEDIF(L2,M2,"m")+IF(AND(EOMONTH(M2,0)=M2,DAY(L2)>DAY(M2)),1,0)
    BF - =X2*BE2
    BG - =X2/AW2*AX2
    BH - =BG2+BF2+BD2
    BI - =IF(W2=0,"0",O2-BH2)

    The final result is in cell BI and i have resorted to hiding them at the moment but is there any chance of getting all of this in one cell?

    Any help would be appreciated

  6. #16
    New Member
    Join Date
    Oct 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    Here are the two formulas that I want together

    1 - =IF((D6=0,"",D6)
    2 - =(DATE(YEAR(D6),MONTH(D6),DAY(D6)+21))

    As you can see, dates are entered in D6 and +21 days are added to that date in another cell, but I don't want the silly 1900-01-21 to appear in that other cell when D6 is blank.... Both formulas work on their own but how do I combine them?

    Thanks in advance (:

  7. #17
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    4,786
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Multiple Formulas in same Cell

    Hi,

    Try it like this:

    =IF(D6=0,"",D6+21)

    Format formula cell as Date.

  8. #18
    New Member
    Join Date
    Oct 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Formulas in same Cell

    It does not work because its a date, the formula to add 21 days is (DATE(YEAR(D6),MONTH(D6),DAY(D6)+21))

    do you think I could enter that instead of the D6+21?

    Thanks for your help (:

  9. #19
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    4,786
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Multiple Formulas in same Cell

    It Does work, have you tried it? Again format formula cell as Date:

    D
    110/25/2018
    2
    3
    4
    5
    610/4/2018

    Sheet310



    Worksheet Formulas
    CellFormula
    D1=IF(D6=0,"",D6+21)



    The Only way it Won't work is if the Date in D6 is Not a real date, but Text.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •