Hi all,
I am a beginner Excel user and need some help coming up with the right formula.
[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]data[/TD]
[TD]100.10[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Check[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]110.00[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Receipt[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]50.01[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Wire[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]32.21[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Receipt[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]45.77[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Receipt[/TD]
[/TR]
</tbody>[/TABLE]
If E1 equals "Check" or "Wire" texts, I need B1 to convert to -100.10 (negative #).
E2 does not equal the "Check" or "Wire" texts, so it stays as 110.00.
What formula would you use? Thank you very much.
I am a beginner Excel user and need some help coming up with the right formula.
[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]data[/TD]
[TD]100.10[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Check[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]110.00[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Receipt[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]50.01[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Wire[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]32.21[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Receipt[/TD]
[/TR]
[TR]
[TD]data[/TD]
[TD]45.77[/TD]
[TD]data[/TD]
[TD]data[/TD]
[TD]Receipt[/TD]
[/TR]
</tbody>[/TABLE]
If E1 equals "Check" or "Wire" texts, I need B1 to convert to -100.10 (negative #).
E2 does not equal the "Check" or "Wire" texts, so it stays as 110.00.
What formula would you use? Thank you very much.
Last edited: