smurphy208
New Member
- Joined
- Dec 27, 2017
- Messages
- 7
Hello-
I have a customer transaction spreadsheet that I export out of QuickBooks and it looks mostly like this:
<tbody>
</tbody>
I'm looking for any suggestions that will look up what is in Column B and if it says "Payment" it will make the value in Column F be a negative. Example Payment of 50.00 would show as -50.00. If it says "Invoice" then it would leave the value as is.
I can get an IF formula to do one or the other but not both together. =IF(B4="Payment",-F4)
I'm sure this is super easy but I can't seem to figure it out, lol.
Thank you so much for your help!
I have a customer transaction spreadsheet that I export out of QuickBooks and it looks mostly like this:
Column A -Customer Name | Column B-Type | Column F-Amount |
01-ABC | Invoice | 50.00 |
Payment | 50.00 | |
Invoice | 100.00 | |
Invoice | 50.00 | |
Payment | 50.00 |
<tbody>
</tbody>
I'm looking for any suggestions that will look up what is in Column B and if it says "Payment" it will make the value in Column F be a negative. Example Payment of 50.00 would show as -50.00. If it says "Invoice" then it would leave the value as is.
I can get an IF formula to do one or the other but not both together. =IF(B4="Payment",-F4)
I'm sure this is super easy but I can't seem to figure it out, lol.
Thank you so much for your help!
Last edited: