formule excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1812239%22%20slang%3D%22en-US%22%3Eformule%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812239%22%20slang%3D%22en-US%22%3E%3CP%3E%3DZ3%3AZ124%2F2*1%2C8*(1-33%25)%20this%20is%20the%20formule%20i%20use%20without%20any%20problems.%20When%20i%20type%200%20in%20the%20cell%20appears%200.%3C%2FP%3E%3CP%3EWhen%20i%20add%26nbsp%3B%3DZ3%3AZ124%2F2*1%2C8*(1-33%25)%2B28%2C14%20the%20result%20is%20correct%20but%20in%20the%20empty%20cells%20appear%2028.%20When%20i%20type%200%20it's%20still%2028%3C%2FP%3E%3CP%3EWhat's%20wrong%20with%20the%20formule.%20When%20i%20type%200%20it%20has%20to%20be%200.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1812239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1812367%22%20slang%3D%22en-US%22%3ERe%3A%20formule%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F843541%22%20target%3D%22_blank%22%3E%40MarcusAurelius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E0%2B28%2C14%20returns%26nbsp%3B28%2C14.%20Why%20it%20shall%20be%200%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1812473%22%20slang%3D%22en-US%22%3ERe%3A%20formule%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1st%20formule%20when%20i%20type%200%20in%20W%20in%20Z%20appears%200%3C%2FP%3E%3CP%3E73%20become%2044%20-%200%20become%200%3C%2FP%3E%3CP%3E2de%20formule%20in%20Z%20stands%20always%2028%3C%2FP%3E%3CP%3E73%20become%2072%20but%20when%20i%20type%200%20it's%2028%20-%20when%20i%20correct%20the%2028%20by%200%2C%20i%20become%20%23%23%23%23%23%23%23%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

=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

@MarcusAurelius 

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

Highlighted

@Sergei Baklan 

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

@MarcusAurelius 

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

image.png

Highlighted
it's just an example
Highlighted

@MarcusAurelius 

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

@Sergei Baklan 

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