#value displayed in a cell that also had #n/a

[Patryd]

HI, need some help with this. This formula removed the #n/a from the cell but it now displays #value. What do I need to add to the formula so that it displays a blank instead of #value

=IF(ISNA(I6),0,I6)-IF(ISNA(G6),0,G6)

 

[Joe4]

See if this formula does what you want:

=IF(ISNUMBER(I6),I6-G6,"")

Be sure to check both when I6 is populated and when it is not.

If it doesn't work, we need to know more about what is showing up in I6.