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

[Auditors]

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	110.00	data	data	Receipt
data	50.01	data	data	Wire
data	32.21	data	data	Receipt
data	45.77	data	data	Receipt

<tbody>
</tbody>

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.

 

[sericom]

If column B isn't a formula, then you'll need to display the result in another column, else use a macro.

 

[Auditors]

You're right, creating a new column and adding the following code worked:

In cell F1, =B1*if(or(E1="Check",E1="Wire"),-1,1)

 

[Macropod]

Cross-posted (and solved) at: Converting a # into negative if the texts is one or the other
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

 

[Auditors]

Oh, I apologize for that. I just read that etiquette link.