IF statement

Occasional Visitor


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,


1 Reply

@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: