IF statement need help

%3CLINGO-SUB%20id%3D%22lingo-sub-1571914%22%20slang%3D%22en-US%22%3EIF%20statement%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571914%22%20slang%3D%22en-US%22%3E%3CP%3EI%20keep%20getting%20a%20%23DIV%2F0%20error%20or%20the%20answer%20to%20the%20calculation%20is%20incorrect.%3C%2FP%3E%3CP%3EI%22m%20using%20the%20following%20formula%20in%20the%20Minority%20%25%20table%3A%3C%2FP%3E%3CP%3E%3DIF(W10%3D0%2C0%25%2C(C10%2BN10%2FW10))%3C%2FP%3E%3CP%3EThe%20number%20of%20black%20males%20in%20official%20%26amp%3B%20administrator%20positions%20(C10)%20%2B%20the%20number%20of%20black%20females%20in%20official%20%26amp%3B%20administrator%20positions%20(N10)%20%2F%20the%20total%20number%20of%20employees%20in%20official%20%26amp%3B%20administrator%20positions%20(W10)%20%3D%20%2F%25%20.%26nbsp%3BIf%20W10%20has%200%20then%200.00%25.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1571914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571938%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751940%22%20target%3D%22_blank%22%3E%40La_La2346%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlternatively%20you%20may%20use%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFERROR(C10%2BN10%2FW10%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I keep getting a #DIV/0 error or the answer to the calculation is incorrect.

I"m using the following formula in the Minority % table:

=IF(W10=0,0%,(C10+N10/W10))

The number of black males in official & administrator positions (C10) + the number of black females in official & administrator positions (N10) / the total number of employees in official & administrator positions (W10) = /% . If W10 has 0 then 0.00%.

 

 

 

 

 

 

 

 

1 Reply
Highlighted

@La_La2346 

Alternatively you may use

=IFERROR(C10+N10/W10,0)