Excel_Inventory.xlsxHello everyone,
I am the type that normally will work through the night to work out a problem but this time I need help
I have a cell with the number 30
then i have cells to the right with header Monday through to Friday
I want it so that if I put 1 in monday the 30 turns to 29
while keeping the 1 in monday
I want it so that if I put 3 in tuesday the 29 turns to 26
while keeping the 1 in monday and 3 in tuesday ect ect
what it is that im doing is i have merchandise and the 30 (for example, could be more or less) is inventory count
and the cells for monday through friday would be the number of sales each day while taking away from the inventory count
I was able to get it to work for monday but the rest I cant figure out
=IF(E5<C5, C5-E5,D5="Soldout")
I would greatly appreciate any help
Thanks
Rob
Bookmarks