Make value negative based off of another cell's value

[PackPariah]

Hello all,

This is my first post on this site but with the personal project I am doing it will probably not be the last.

Background on project:

Trying to create a personal finance tracker that will work across multiple devices (i.e home computer, wife and I's cellphones, etc.) and is very intuitive. Currently I am working on making a data entry page that dumps all data into another sheet that will represent checking account and will be pivoted so allow for sorting etc..

Right now I have a sheet that has two entries, spending type (drop down list with withdraw or deposit) and total amount. What I am trying to achieve is a simple way to insert a value that will be dumped in with the rest of the data on another sheet which data calculations (such as total) will be derived from later on.

One road block I have hit is trying to get the value entered into the "total amount" cell to be negative or positive depending on what is selected in the "spending type" cell.

Does anybody know the best way to accomplish this?

I have tried multiple "if" statements with no success.

Thank you in advance

 

[SyedUsman]

Dear PackParish

Welcome to the board

You cannot have both the input cell & the if statement in the same cell

i suggest you use a helper column for data entry

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Input Cell[/TD]
[TD]Spending Type[/TD]
[TD]Total Amount[/TD]
[/TR]
[TR]
[TD]1,000[/TD]
[TD]Withdrawal [/TD]
[TD]=IF(Spending type="Withdrawal",-Input Cell ,Input Cell)[/TD]
[/TR]
</tbody>[/TABLE]






Let me know if it helps.