Highlighted
New Contributor

# formule excel

=Z3:Z124/2*1,8*(1-33%) this is the formule i use without any problems. When i type 0 in the cell appears 0.

When i add =Z3:Z124/2*1,8*(1-33%)+28,14 the result is correct but in the empty cells appear 28. When i type 0 it's still 28

What's wrong with the formule. When i type 0 it has to be 0.

6 Replies
Highlighted

# Re: formule excel

0+28,14 returns 28,14. Why it shall be 0?

Highlighted

# Re: formule excel

1st formule when i type 0 in W in Z appears 0

73 become 44 - 0 become 0

2de formule in Z stands always 28

73 become 72 but when i type 0 it's 28 - when i correct the 28 by 0, i become #######

Highlighted

# Re: formule excel

In the file I didn't file formulas from your post and column Z is empty. Where they are?

Highlighted

# Re: formule excel

it's just an example
Highlighted

# Re: formule excel

Perhaps I missed something, but in your sample file everything works correctly.  Could you please indicate which exactly cell in the sample file returns not expected result and what it shall be.

Highlighted

# Re: formule excel

The are some koloms hidden, I've already find a solution by typing -47 and then the formula give 0.