Forum Discussion

Heidy_Her's avatar
Heidy_Her
Copper Contributor
Dec 04, 2021

IF statement

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

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 05, 2021

    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)

     

Resources