I need help creating a formula that basically says:
IF E12="Income" then the number typed in f12 will be positive
If e12="expense" then the number typed in f12 will be negative
Just trying to eliminate some work as I'm a profit and loss analyst and type thousands of numbers a day...
Example below:
<tbody>
</tbody>
Thanks in Advance:
Haley
IF E12="Income" then the number typed in f12 will be positive
If e12="expense" then the number typed in f12 will be negative
Just trying to eliminate some work as I'm a profit and loss analyst and type thousands of numbers a day...
Example below:
Transaction Type | Amount | ||
Income | $55.00 | ||
Expense | -$100 |
<tbody>
</tbody>
Thanks in Advance:
Haley