[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

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.

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.