Simple algebra and excel

[Brandon.Galindo]

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

 

[Richard O. Neville]

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

 

[Roger Govier]

Hi Brandon

Try the array entered formula
{=SUM(IF(A1:A3=INT(A1:A3),A1:A3,0))}

To commit or edit an array formula, use Control+Shift+Enter (CSE) not
just Enter.
Excel will insert the curly braces { } when you use CSE. Do not type
them yourself.

 

[joeu2004]

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;

 

[Brandon G.]

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 -


general;-general;

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

 

[Guest]

Goto Tools ~ Options ~ View and unselect Zero Values (Office 2003)