Converting a # into negative if the texts is one or the other

Hi all,

I am a beginner Excel user and need some help coming up with the right formula.

data	100.10	data	data	Check
data	54.45	data	data	Receipt
data	23.12	data	data	Wire
data	299.18	data	data	Receipt
data	54.77	data	data	Receipt

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.

Hi welcome to the forum

Try this...
=B1*if(or(E1="CHECK",E1="Wire"),-1,1)

Sorry, where is the value you need to be converted?

Change the reference xxxxxxx to that....
=xxxxxx*if(or(E1="CHECK",E1="Wire"),-1,1)

Are the values in column B hard numbers or there formulas in B that return those values? If they are hard numbers you'll need a separate formula like Ford wrote, or you'll need a macro (Visual Basic for Applications a.ka. VBA).

If they are formulas you could try something similar directly in column B ... something like this

=<your formula>*if(or(E1="CHECK",E1="Wire"),-1,1)

Thank you Dave and Ford. Column B were hard numbers; creating a new column and using Ford's formula worked.

[SOLVED]

Cross-posted at: http://www.mrexcel.com/forum/excel-q...one-other.html
For cross-posting etiquette, please read FORUM RULE 8: http://www.excelforum.com/forum-rule...rum-rules.html