Mar 12 2019 08:47 AM
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?
Mar 12 2019 10:59 AM
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.
Mar 12 2019 02:11 PM
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
Mar 13 2019 02:40 PM
Your formula works well so I switch it to that. Thank you for your help!