Google Spreadsheet Post #2304
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Nov-26-2017
question by: Evelyn Brooks
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/9FQo8uiYjF0/RVgQeKCvBQAJ
How can I lock a cell ref from changing to a negative number
I have a shared sheet with different available products. I have a row with names for each person I share it with and a column with the quantity available, so I set it up with the sum formula so when each person puts in the quantity they would like it deducts the quantity left. My problem is once the total quantity left hits 0 people can continue to input an amount so the total becomes negative and I don't know who requested what 1st.
I have a shared sheet with different available products. I have a row with names for each person I share it with and a column with the quantity available, so I set it up with the sum formula so when each person puts in the quantity they would like it deducts the quantity left. My problem is once the total quantity left hits 0 people can continue to input an amount so the total becomes negative and I don't know who requested what 1st.
Column D I have added this equation so I know how much product is left:
So I want to know if there is a way to keep the cell with the Available quantity from locking at 0? That way I know the product is sold out.
https://docs.google.com/
No comments:
Post a Comment