I'm struggling to get a negative number for accounting!

StevieC

So I have incomings and outgoings but I cant find a formula to turn my outgoings into negative numbers?

The bank payment column is a drop down so when I select an outgoing I need my figures to become negative, what formula do I need to use?

Jeremy_D

So I understand, is the 'Total' a formula? I'm guessing of VAT@row + Net@row?

You could just amend it with an IF statement. So e.g. =IF([Bank Payment]@row = "Outgoing", 0 - (VAT@row + Net@row), VAT@row + Net@row)

That basiacally says if the bank pament is "Outgoing" (or whatever drop down options are outgoing. You can use an OR function to include multiple options), then take 0 and minus the total (making it negative), otherwise calculate the total.

Hope that makes sense? That's one way of doing it.

Jeremy_D

So I understand, is the 'Total' a formula? I'm guessing of VAT@row + Net@row?

You could just amend it with an IF statement. So e.g. =IF([Bank Payment]@row = "Outgoing", 0 - (VAT@row + Net@row), VAT@row + Net@row)

That basiacally says if the bank pament is "Outgoing" (or whatever drop down options are outgoing. You can use an OR function to include multiple options), then take 0 and minus the total (making it negative), otherwise calculate the total.

Hope that makes sense? That's one way of doing it.

StevieC

You're the man Jeremy, I've been trying similar formulas but I couldn't get it! Thank you.