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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]-9
[/TD]
[TD]oil
[/TD]
[TD]oil (if A is negative, give the text contained in B; if A is >=0, give 0)
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]7
[/TD]
[TD]gas
[/TD]
[TD]gas (if A is positive, give the text contained in B; if A is <=0, give 0)
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0 (if A is zero, give 0)
[/TD]
[/TR]
</tbody>[/TABLE]
I hope I was clear.
Thanks,
Amanda
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]-9
[/TD]
[TD]oil
[/TD]
[TD]oil (if A is negative, give the text contained in B; if A is >=0, give 0)
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]7
[/TD]
[TD]gas
[/TD]
[TD]gas (if A is positive, give the text contained in B; if A is <=0, give 0)
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0 (if A is zero, give 0)
[/TD]
[/TR]
</tbody>[/TABLE]
I hope I was clear.
Thanks,
Amanda