How to subtract multiple cells from a cell and report soldout when main number reaches 0

**QuietForce** · 11-01-2012, 11:37 PM

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

**Sindhus** · 11-01-2012, 11:43 PM

Hi QuietForce, welcome to the forum!

Please change the title of your thread as per the forum rules. And if you can attach a workbook, with your expected results, we can better understand your requirement.

Regards,
Sindhu

**QuietForce** · 11-01-2012, 11:50 PM

Thank you, will do

**QuietForce** · 11-02-2012, 01:43 AM

Hey guys

I didnt figure it out EXACTLY how I wanted it but

in the beginning it says None Sold and will count down to 0 but wont say sold out

thats ok i guess. just have to pay attention for the 0

this is the code i came up with after playing with it for awhile

=IF(D5<>C5,C5-(SUM(E5:J5)),"None Sold")

Thanks anyways

Rob