Formula and Possible Macro Help
Posted by James Elliott on December 18, 2001 12:58 PM
Hi there! I am trying to write a formula where a total percentage is calculated from taking the status of six dropdown boxes (ex. if three dropdowns have the choice "completed" marked, then I want a column that I have marked "overall completion status" to say 50%)
Does anyone know how to write a formula for this or if I have to write a macro? I can email anyone the sheet to take a look at if they are interested.
Thanks for your help!