Hi Excel Gurus,
I have 2 tables, Stock availability and Sold item. Not sure if this is possible using excel if else and formula to subtract the availability stock.
If D3 or D4 filled with text available in A3:A4, then it take the quantity on E3 to subtract B3 and E4 subtract B4.
Thank you in advanced.
I have 2 tables, Stock availability and Sold item. Not sure if this is possible using excel if else and formula to subtract the availability stock.
If D3 or D4 filled with text available in A3:A4, then it take the quantity on E3 to subtract B3 and E4 subtract B4.
Thank you in advanced.