Home

Inventory formula

Highlighted
marysha
New Contributor

I sell items at craft fairs every year and I'm trying to create a formula in Excel to assist with tracking this that goes slightly beyond the basic subtraction.  For example, if cell E2 is my inventory before the event, F2 is my inventory after the event, G2 is the number of inventory sold at the event.  BUT if F2 is blank I want G2 to reflect 0.  How do I set that formula up?

4 Replies
Highlighted

In G2 it could be

=NOT(ISBLANK(F2))*(E2-F2)
Highlighted

Thank you.  I'll try that too.  I did find if I created a hidden column G, I was able to use the IFS formula in column H.

Highlighted

That's a bit different logic behind. In your first screenshort Sold was in G2, now it is in H2 and not clear what G2 means

Highlighted

Your formula works well so I switch it to that.  Thank you for your help!

Related Conversations
Inventory Automation
Mo_Rne in Excel on
1 Replies
Leap year formula
Hattsoff in Excel on
4 Replies
Registration of inventory in Kaizala
Henrik Konnerup in Microsoft Kaizala on
0 Replies