08-06-2020 03:21 PM
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%.
08-06-2020 03:32 PM