Recent content by Jstdv8

thats exactly it. I was making it way more complicated than it had to be. Thank you gaain for your timely response, this site is a lifesaver

Bob, Ok so I was using my new spreadsheet and I came up with a problem I need resolved with the same formula. Everything works as i had hoped. But I need it to show negative values when when the quantity I'm taking out of stock (A2-A7) exceeds the quantity i input in A1. Since we used absolute...

genius! I never would have gotten there by myself. thank you so much! Justin

I would like to make a formula that would allow me to take a series of cells and add them up AND subtract them from another cell. So say A1 is my original number and then each time someone takes something out of stock I enter it into A2, then another customer comes and takes more and that...