Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hello,
    I am new with excel and just know the basics.
    Dealing with a simple SUM Equation I would like to have a "Word" (not as in MS WORD ) answer. For Example:

    SUM="Who" IF < 100
    SUM="What" IF = 200
    SUM="I Don't Know" IF > 300

    Is there a way to do this? Thanks.
    Time can fix anything.....even a broken clock. - Handy Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='HandyAndy' post='768402' date='31-Mar-2009 08:02']Hello,
    I am new with excel and just know the basics.
    Dealing with a simple SUM Equation I would like to have a "Word" (not as in MS WORD ) answer. For Example:

    SUM="Who" IF < 100
    SUM="What" IF = 200
    SUM="I Don't Know" IF > 300

    Is there a way to do this? Thanks.[/quote]
    Your conditions aren't exhaustive - what if the sum is 160 or 270?

    One option would be to use another cell to display the text. With the SUM formula in B5, you could use a formula like this in B6:

    =IF(B5<100,"Who",IF(B5>300,"I Don't Know","What"))

    Another option is to apply a custom format to the cell with the SUM formula in the Number tab of Format | Cells..., for example

    [<100]"Who";[>300]"I Don't Know";"What"

    See the attached workbook: [attachment=83156:SumDemo.xls]
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='768404' date='31-Mar-2009 02:13']Your conditions aren't exhaustive - what if the sum is 160 or 270?

    One option would be to use another cell to display the text. With the SUM formula in B5, you could use a formula like this in B6:

    =IF(B5<100,"Who",IF(B5>300,"I Don't Know","What"))

    Another option is to apply a custom format to the cell with the SUM formula in the Number tab of Format | Cells..., for example

    [<100]"Who";[>300]"I Don't Know";"What"

    See the attached workbook: [attachment=83156:SumDemo.xls][/quote]

    Thanks so much. I can work on your example and play around with it. Like I said I am not too familiar with excel, and I'm baffled by your magic on the integration of the "Format:" Cell in the equation. Thanks, again.
    Time can fix anything.....even a broken clock. - Handy Andy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    For more info on custom number formats, see:
    Create or delete a custom number format (click Show All to see all content)
    Number Formats in Microsoft Excel
    Excel Custom Number Formats

  5. #5
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='768410' date='31-Mar-2009 03:01']For more info on custom number formats, see:
    Create or delete a custom number format (click Show All to see all content)
    Number Formats in Microsoft Excel
    Excel Custom Number Formats[/quote]
    I think I got it, so the only purpose for the format cell is to show you where the word answer came from, right?
    Time can fix anything.....even a broken clock. - Handy Andy

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Format | Cells... can be used to control almost all aspects of the way a cell is displayed - not only the number format, but also the font and text alignment, the cell borders, the background color and cell protection.

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Thought this excelent Post by Hans on complex Excel formulas may be of assistance to you. Post 702972

    Regards,

    Tom Duthie

Posting Permissions

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