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
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

@MarcusAurelius 

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

@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 #######

@MarcusAurelius 

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

image.png

it's just an example

@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.

@Sergei Baklan 

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