series of conditions in the same formula

[AmandaSS]

Hi,
I have the data in A and B, I would like a formula in C that gives as a results the text contained in B, or zero.
Please note that A can be either >, < or =0. In B there is text or value (zero).
The formula in C should be able to recognize whether the value in A is positive/negative or zero, and give as a result the corresponding text (or zero value) contained in C.

	A	B	C
1	-9	oil	oil (if A is negative, give the text contained in B; if A is >=0, give 0)
2	7	gas	gas (if A is positive, give the text contained in B; if A is <=0, give 0)
3	0	0	0 (if A is zero, give 0)

<tbody>
</tbody>

I hope I was clear.
Thanks,
Amanda

 

[Aladin Akyurek]

C1, copied down:

=IF(A1 < 0, B1, 0)