how to calculate 60% of a total in £

%3CLINGO-SUB%20id%3D%22lingo-sub-2070831%22%20slang%3D%22en-US%22%3Ehow%20to%20calculate%2060%25%20of%20a%20total%20in%20%C2%A3%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070831%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIt%20is%20my%20first%20time%20using%20a%20formula%20in%20excel%20apart%20from%20basic%20adding%20etc%20in%20more%20than%2010%20years%20so%20would%20kindly%20appreciate%20your%20help%20in%20very%20basic%20beginners%20terms%20please!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20have%203%20different%20streams%20of%20income%20listed%20in%20C3%2C%20D3%20and%20E3%20and%20their%20total%20in%20F3.%20The%20weeks%20are%20listed%20in%20A3%2C%20A4%2C%20A5%20etc.%20In%20G3%20I%20am%20trying%20to%20calculate%2060%25%20of%20F3%20in%20%C2%A3.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%20C3%20%C2%A350%2C%20D3%20%C2%A340%2C%20E3%20%C2%A390%2C%20F3%20(TOTAL)%20%3D%20%C2%A3180.00%2C%20G3%20(60%25)%20%3D%20%C2%A3108.00%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20this%20calculation%20please%20which%20will%20display%20in%20%C2%A3.%3C%2FP%3E%3CP%3EThank%20you!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2070831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2070853%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20calculate%2060%25%20of%20a%20total%20in%20%C2%A3%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933200%22%20target%3D%22_blank%22%3E%40remyk14%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20very%20simple%3A%20enter%20the%20following%20formula%20in%20G3%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D60%25*F3%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20necessary%2C%20format%20G3%20as%20currency.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 different streams of income listed in C3, D3 and E3 and their total in F3. The weeks are listed in A3, A4, A5 etc. In G3 I am trying to calculate 60% of F3 in £.

 

E.g. C3 £50, D3 £40, E3 £90, F3 (TOTAL) = £180.00, G3 (60%) = £108.00

 

How can I get this calculation please which will display in £.

Thank you!!!

 

2 Replies

@remyk14 

It's very simple: enter the following formula in G3:

 

=60%*F3

 

If necessary, format G3 as currency.

@Hans Vogelaar 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!