Forum Discussion
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...
ozzie4khawaja Sorry, you loose me here. I know nothing about football and find the form quite confusing. Kindly fill it in with an example and indicate where the calculation is made and what's wrong.
Ok i'll send you the screenshots for you to see, hopefully that will help
- Now attached, i've highlighted the formula i've used, the cells involved and the table which is on another tab. Hopefully this should remove any confusion.
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.
- Hi Riny, thank you so so so much. I've managed to get it to work, finally.