Forum Discussion
Inventory formula
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 invento...
In G2 it could be
=NOT(ISBLANK(F2))*(E2-F2)
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.
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
Your formula works well so I switch it to that. Thank you for your help!