How to add percentage with a blank cell and get the result in percentage format?
Hello everyone, I am adding 2 different Efficiencies to show the Total efficiency. When there are values in the cell it works just fine, but when I am adding a percentage with a blank cell (or even a Zero) , the final result doesn't get converted to the Percentage format. Any idea how I can make the values in percentage format? Thank you!
Help Article Resources
Check out the Formula Handbook template!