Sum in table without zero value showing

[Bedford]

I have a simple formula that I hoped would result in a blank cell rather than a zero when the cells being calculated are empty, formula is; =SUM(IFERROR([@[Qty IN]]-[@[Qty OUT]],0))

Anyone can help with a completely empty cell when qty in and qty out are empty?
Thank you in advance.

 

[BSALV]

or
- conditional format and give 0 an almost white font color
- or in File>options>Advanced and your tabname unselect "show zero in case of a value zero"

Display or hide zero values - Microsoft Support

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

support.microsoft.com

 

[bebo021999]

Or
=SUM(IFERROR([@[Qty IN]]-[@[Qty OUT]],""))

 

[Bedford]

=SUM(IFERROR([@[Qty IN]]-[@[Qty OUT]],""))

I tried this formula, but it too returned a zero in the cell. Having given this inventory control, check-in / check-out workbook more thought, I think it's what we need, if there is no stock on this item, then we need it to state as such. More importantly what we're noticing, we can view the instances of Qty IN and Qty OUT frequencies with dates, time, name of person checking in or out the goods, but what I see we are now faced with is the current qty in house of any particular product code at a glance. We have a column that tabulates the specific line item but it doesn't take into account the balance from previous entries of that product code. I now am needing a solution for that.

 

[BSALV]

i preferred a formula like

=IFERROR([@[Qty IN]]-[@[Qty OUT]],"---")

to mark errors and then the conditional format or the setting for the sheet to hide the zeros

 

[Bedford]

i preferred a formula like

=IFERROR([@[Qty IN]]-[@[Qty OUT]],"---")

to mark errors and then the conditional format or the setting for the sheet to hide the zeros

Hi Bsalv, much thanks.