Question: 1. You will need to add a column and create a function that calculates Cash Flow based on criteria from Type. Create an IF statement

1. You will need to 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.What formula do i use for it?

Date Day of Week Account Type Amount Cash Flow Customer Branch 1-Aug Friday Savings New Account 3000 New Anderson Hills 1-Aug Friday Checking New Account 380 New Blue Ash 1-Aug Friday Checking New Account 3070 New Anderson Hills 1-Aug Friday Checking New Account 3560 New Blue Ash 1-Aug Friday Checking New Account 620 New Anderson Hills 1-Aug Friday Certificate of Deposit New Account 39700 New Blue Ash 1-Aug Friday Certificate of Deposit New Account 49300 New Delhi 1-Aug Friday Certificate of Deposit New Account 19600 New Blue Ash 1-Aug Friday Savings Deposit 3000 Current Delhi 1-Aug Friday Savings Deposit 1100 Current Anderson Hills 1-Aug Friday Savings Deposit 1500 Current Anderson Hills 1-Aug Friday IRA Current Contribution 1100 Current Anderson Hills 1-Aug Friday Checking Withdrawal 3800 Current Anderson Hills 1-Aug Friday Checking Deposit 3550 Current Anderson Hills 1-Aug Friday Checking Deposit 940 Current Blue Ash 1-Aug Friday Checking Deposit 250 Current Delhi 1-Aug Friday Checking Deposit 3090 Current Anderson Hills 1-Aug Friday Checking Withdrawal 890 Current Anderson Hills 1-Aug Friday Checking Deposit 760 Current Blue Ash 1-Aug Friday Checking Deposit 750 Current Anderson Hills 1-Aug Friday Checking Withdrawal 420 Current Anderson Hills 1-Aug Friday Checking Deposit 140 Current Anderson Hills 1-Aug Friday Checking Withdrawal 930 Current Blue Ash 1-Aug Friday Checking Withdrawal 330 Current Anderson Hills 1-Aug Friday Checking Withdrawal 130 Current Anderson Hills 1-Aug Friday Checking Deposit 170 Current Anderson Hills 1-Aug Friday Checking Deposit 980 Current Delhi

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1. You will need to 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...

1. Note that it is difficult to determine whether each transaction in the Amount column represents a positive cash inflow or a negative cash outflow without information in other columns. Modify the...

please help me with the formulas 1. You will need to 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...

Paste B I U. : Me E15 X fx 3550 B D E F G 1 Date Day of Week 2. 1-Aug Friday 3 1-Aug Friday 4 1.Aug Friday 5 1-Aug Friday 6 1-Aug Friday 7 1-Aug Friday 8 1-Aug Friday 9 1-Aug Friday 10 1-Aug Friday...

Here are some details you need to complete the file. 1. You will need to add a column and create a function that calculates Cash Flow based on criteria from Type. Create an IF statement that returns...

Business Analytics, 3rd Edition ISBN: 9780135231715 By: James R. Evans (pg 81). The Peoples Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson...

1.You will need to 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...

You will need to 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 ( $ 5 0 0 . 0 0 ) for...

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...

The Peoples 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...

Obtain PDE from z=f(sin x + cos y).

The importance of cash budgets for all types of businesses and individuals cannot be overemphasized. The following six steps to cash flow control are critical. 1. Create a monthly cash flow budget....

A company has originally entimated its valaple manufactuing overhead costs to be 5 3 9 0 , 0 0 0 but had actual variable mandacturing oveitead conss of $ 2 1 0 , 0 0 0 . The company used a standand...

Sales Pitch! I am in need of some information about indole ( from SIM) 2What does your product do, and when would this product be useful? 3. How do I run tests with this product? How do I read the...

3. Demand curves slope downward because, other things held equal, LO7.3 a. An increase in a products price lowers MU. b. A decrease in a products price lowers MU. c. A decrease in a products price...

LO8.1 Define behavioral economics and explain how it contrasts with neoclassical economics.

3. advanced analysis First, graphically illustrate a doubling of income without price changes in the indifference curve model. Next, on the same graph, show a situation in which the person whose...