Formula Help

[Slythe]

Hi,

I was wondering if anyone knows of a formula that you can use to hide a formula if it isnt needed;

For example, if you had some data on one sheet and you wanted it adding up, but only when another cell has some text entered into it, and whilst there is no text in that cell, the cell where the addition formula is appears blank.

Any help would be appriciated
Regards Si

 

[Andrew Poulsom]

Like this?

=IF(ISBLANK(A1),"",SUM(B1:B10))

Change the range references to suit.

 

[cstlaurent]

try this

if(a1<>"",b1+b2,"")

a1 is the condition cell, if a1 is not empty then aply the formula.

b1 + b2 is your formula

 

[Slythe]

Cheers,

I had more sucess with the first solution with what i was doing, for some reason the second one wasnt adding up the range even if i changed the b[row number]+b[row number] to a ":" for some reason.

Thanks all the same