Forum Discussion
remyk14
Jan 18, 2021Copper Contributor
how to calculate 60% of a total in £
Hi It is my first time using a formula in excel apart from basic adding etc in more than 10 years so would kindly appreciate your help in very basic beginners terms please!! Basically I have 3 d...
HansVogelaar
Jan 18, 2021MVP
It's very simple: enter the following formula in G3:
=60%*F3
If necessary, format G3 as currency.
- remyk14Jan 18, 2021Copper Contributor
HansVogelaar thank you so much for such a quick reply and for your help! I know it was very basic and i've been looking online for the past few days and google was just showing complicated formulas. You've made my day! 🙂