On Mar 8, 12:51 pm, "joeu2004" wrote:
On Mar 8, 8:50 am, "

wrote:
I only want excel to populate the field if there
is a positve or negative integer?

I think you mean that you want Excel to __display__ only non-zero
values. Two ways to accomplish that:

=if(expression = 0, "", expression)

Note that that requires the expression to evaluated twice :-(.
Alternatively, create a custom format by clicking on Format - Cells -

Number - Custom. Perhaps the following will meet your needs:

general;-general;

okay so how do I compound that with the formula that I am using =g5+j5-
k5