Question

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson Hills. The Excel file Peoples Choice Bank is a database of major account transactions for the month of August.

How can I add a column and create a function that calculates Cash Flow based on criteria from Type. Create an IF statement that returns a negative cash flow (looks like ($500.00) for example) if the type was a Withdrawal. For all other types, the cash flow should be positive.

Answer 1

Apply IF formula as

	A	B	C
1	Type	Cash	Net
2	Withdrawal	500	=IF(A2="withdrawal",-B6,B6)
3	Deposit	200	=IF(A2="withdrawal",-B6,B6)

Logic of formula: IF(Logic_test,[value if true],[value_if_false]

Step 2 : In the Net column select the whole column and go to "home" then in number tab select type as "currency"

Please let me know if you face any difficulty in applying the formula. Please give thumps up if you are satisfied with my answer.