Skip empty cell in formula

Hi there,

Im trying to make a simple formula in excel but I can't get what I want. Maybe there is someone here that can give me some help.

I want to make the formula: x=SUM(A * e^(-b*d)), wherein A and b are parameters and d the distance.

I've just over 10.000 rows and 15 columns (B4 to P10013) with distances. For each column i give a formula =$S$2*EXP(-$R$2*B4) and extent that for all colums and rows, then I sum all the columns. This works fine, except for the fact that when there is an empty cell the outcome is wrong. Because I set for example A as 10. The answer for that cell is 10, because he sees an empty cell as 0, i guess.

So how do I skip these empty cells?

Given the actual formula..
=$S$2*EXP(-$R$2*B4)

Which cell might be blank (S2 R2 or B4) ?
And what result do you want when it is blank?

Originally Posted by Jonmo1

Given the actual formula..
=$S$2*EXP(-$R$2*B4)

Which cell might be blank (S2 R2 or B4) ?
And what result do you want when it is blank?

B4 is just the first cell but in like 75% of the rows there is at least one cell empty. S2 and R2 are both the parameters that I can set. So the B4 changes over B4 to P10013.

When its blank it should just be zero. So that when it is summed up, it is left out.

Try

=IF(B4="",0,$S$2*EXP(-$R$2*B4))

Originally Posted by Jonmo1

Try

=IF(B4="",0,$S$2*EXP(-$R$2*B4))

Thank you, thats it. It is much more easier than I had anticipated.

You're welcome.