IF statement

[Heidy_Her]

Hi,

Can someone please help me? I need to create an IF statement that returns a negative cash flow (looks like ($500)) for example,  based on criteria from type if the type was a withdrawal; the type options I have are  new account, deposit, withdrawal, and current contribution. I would really appreciate your help.

thank you,

Heidy

[#2]

@Heidy_Her Let's assume that the transaction type is in column B and the amount in C. Starting on the second row, the a formula in D2 could be:

=IF(B2="Withdrawl",-C2,C2)