Forum Discussion
ozzie4khawaja
Mar 11, 2021Copper Contributor
Finding the Right Excel Formula and putting it together
Hi All, This is my first time using this forum but I've hit a roadblock. I'm trying to create a tool/calculator for the line of work which is scouting football/soccer players across the world and to...
Riny_van_Eekelen
Mar 12, 2021Platinum Contributor
ozzie4khawaja Since you didn't attach the actual sheet with the formula in it, I did something in the one you did upload earlier. Attaching it below.
J2 is a number, H2 is formatted as text (!) and I entered "25%" (without the quotes) and the result is displayed in L2. Seems correct to me. Hopefully you can replicate it in your own workbook.
ozzie4khawaja
Mar 17, 2021Copper Contributor
Hi Riny, thank you so so so much. I've managed to get it to work, finally.