Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Multiple Formulas in same Cell

  1. #11
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,664
    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,664
    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
    34
    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

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
  •