# Thread: Numeric Equation Leaving Alphabetic Solution

1. 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.

2. [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]

3. [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.

Create or delete a custom number format (click Show All to see all content)
Number Formats in Microsoft Excel
Excel Custom Number Formats

5. [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?

6. 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. 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
•