Text interpretation

[philliphawken]

Hi,
I would like to use excel to automatically determine an text interpretation based on the numerical data that is entered into 3 other cells.
Example:
A1, B1 & C1 are all cells that contain numerical data. D1 needs a "final result" based on the numbers in the other cells.

If A1 is 0, B1 is <5 and C1 is <50%, then D1 is Negative.
If A1 is 0, B1 is <5 and C1 is >=50%, then D1 is Positive, etc.....

Any help, ideas or suggestions are more than welcome.
Thanks,
Phil

[AliGW]

What do you expect to see in D1?

[philliphawken]

D1 will contain a pre-defined text, e.g. Negative, Positive, etc.

[AliGW]

OK. Try this in D1:

=IF(AND(A1=0,B1<5,C1<50%),"Negative",IF(AND(A1=0,B1<5,C1>=50%),"Positive",""))

If this doesn't work, try this:

=IF(AND(A1=0,B1<5,C1"<50%"),"Negative",IF(AND(A1=0,B1<5,C1">=50%"),"Positive",""))

This will return a blank cell if neither of the two sets of criteria is met.

[philliphawken]

Oh awesome - that seems to work perfectly. Presumably I can then continue with IF statements when there are more than 2 possible outcomes??

For the text result in D1, is it possible to get excel to enter a pre-listed result (e.g. typed into another cell - Z1), or do I have to type the text inside the " " of the formula each time??

[AliGW]

Yes, you an continue to nest IF statements, but if there are a lot, you might want to consider some sort of lookup table instead.

The text can just as easily be a cell reference where the text is stored, and if that is the case, no " " is required.