Forum Discussion

Carl_61's avatar
Carl_61
Iron Contributor
Oct 13, 2021
Solved

Formula Help

I have the formula shown below which works but I need help with resulting in the proper percentage format. The formula references cell D34 which has "18 Units" in the cell.  It is a mixed cell of nu...
Formulas and Functions
  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Oct 13, 2021

    Carl_61 

    Remember if it worked please flag it as solved and hit the like button.

     

    1 - A simple solution by formatting the cell as Percentage

    2- Or wrap up the result with another formula

     

    =TEXT(PreviousFormula,"0.00%")

     

     

     

Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Oct 13, 2021

Carl_61 

{=(317-SUBSTITUTE(D34,RIGHT(D34,LEN(D34)-MAX(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},D34),""))),""))/317}

 

You can also simplify by using the following formula

=(317-VALUE(LEFT(D34,FIND(" ",D34,1)-1)))/317

 

 

 

Carl_61's avatar
Carl_61
Iron Contributor
Oct 13, 2021
Thank you I tried your formula. It gives me my results but how can I format the percentage to say like 94.32%. You know rounding to the nearest 2 digits beyond the . (period)