For some reason, I can't figure out why this isn't working. Column is all currency. I need G2 to eventually get to $0 when I put in my amounts in G10 to G? I have tried using positive and negative numbers. How I think my formula should look: =600-(G10+G100) Keep getting error. Or =600-(G10:G100) gets error too. Also have tried
=G10-(G10:G100)