Try an IF function: if (cell containing result) is 0, enter result,
otherwise enter nothing.

wrote in message
ups.com...
Okay so I have came accross another question regarding a simple
algebraic question. I am using a function like a1+a2+a3=

when there are values in a1-3 excel places a 0 in the field which is
ofcourse correct but I only want excel to populate the field if there
is a positve or negative integer?

Thanks for your help This discussion group rocks!

Brandon