Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Multiple Formulas in same Cell

This is a discussion on Multiple Formulas in same Cell within the Excel Questions forums, part of the Question Forums category; Is there a way to use multiple formulas for just one cell without damaging the others? Thanks!...

  1. #1
    Board Regular gymwrecker's Avatar
    Join Date
    Apr 2002
    Location
    Fort Knox, KY
    Posts
    300

    Default

    Is there a way to use multiple formulas for just one cell without damaging the others?

    Thanks!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    547

    Default

    I'm not clear on the multiple formulas for just one cell care to explain a little more


  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Allentown, PA
    Posts
    2,543

    Default

    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.
    ~Anne Troy

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790

    Default

    Hold on Dreamboat, let's find out what he wants first...!

    =MAX(A1:A20)&" "&MIN(B1:B20) are two different formulae in a single cell (albeit represented by a single formula)

    Gymwrecker : if you mean have a cell that says "Monthly sales were" and then has a formula which relates the monthly sales, followed by "and yearly average was" followed by a different formula which computes this, all in the same cell, then the answer is yes....

    is this the kind of thing you were thinking of ?

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,114

    Default

    one cell can carry more or less what you like as long as the syntax is correct one formul??? no you can bolt to many again subject to syntax and yhe & will all continualtion so i see that as what ever goes???

    Im with you chris

    I beleive what Dreamboat refers to is nesting, not bolting.. nest = 1, bold = more

    both will work...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    New Member
    Join Date
    Oct 2010
    Posts
    9

    Default Fraction rounding

    90.000+
    12.493
    -------------------------
    Result would be 102.493
    but i need to formula (sum+round) result as 102.500

  7. #7
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,499

    Default Re: Multiple Formulas in same Cell

    Try

    =ROUND(90+12.493,1)
    HTH, Peter
    Please test any code on a copy of your workbook.

  8. #8
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,123

    Default Re: Multiple Formulas in same Cell

    Always better to open a new thread if you have a question not directly related to a previous thread.

    Nonetheless, assuming 90.000 is in A1 and 12.493 is in A2, try:

    Code:
    =ROUND(A1+A2,1)
    Matty

  9. #9
    New Member
    Join Date
    Oct 2010
    Posts
    9

    Default Re: Multiple Formulas in same Cell

    sorry for the inconvenience , i will follow the proceedure
    tks

  10. #10
    New Member
    Join Date
    Jan 2012
    Posts
    2

    Default Re: Multiple Formulas in same Cell

    So, I have a question on using multiple formulas as well.... I want the same cell to have these 2 formaulas: =M15-IF(M15>40,40,0) AND =MAX(0,K12-40)
    So, if cell A shows 45, I want cell B to show only what is over 40 (5), but if cell A is less than 40 I want cell B to say 0..... does that make any sense? Sorry, I am new to this. Appreciate your help!!!

Page 1 of 2 12 LastLast

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
  •  


DMCA.com