How to calculate 25% of the sum in a specific cell?

%3CLINGO-SUB%20id%3D%22lingo-sub-1147090%22%20slang%3D%22en-US%22%3EHow%20to%20calculate%2025%25%20of%20the%20sum%20in%20a%20specific%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1147090%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%2C%20but%20I'm%20not%20a%20native%20English%20speaker%20and%20I%20better%20explain%20this%20as%20simple%20and%20graphic%20as%20I%20can%3A%26nbsp%3B%3CBR%20%2F%3EMy%20friend%20has%20a%20business%20and%20he%20wants%20to%20give%20his%20costumers%20a%20note%20he%20is%20writing%20in%20Excel%2C%26nbsp%3Bshowing%20how%20much%20each%20item%20they%20have%20bought%20cost%2C%20and%20then%20the%20sum%20without%2025%25%20tax%2C%20then%20how%20much%20the%2025%25%20tax%20is%2C%26nbsp%3B%20and%20at%20the%20end%20the%20sum%20incl%20tax.%3CBR%20%2F%3E%3CBR%20%2F%3ELet's%20say%20the%20numbers%20are%20written%20in%20column%20C%3A%3CBR%20%2F%3EFrom%20C1%20to%20C10%20we%20have%20a%20list%20of%20the%20cost%20of%20each%20item%2C%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3EC11%20shows%20the%20sum%20of%20C1%20to%20C10%20(without%2025%25%20VAT)%26nbsp%3B%3CBR%20%2F%3EC12%20shows%20much%20much%20the%2025%25%20VAT%20is%26nbsp%3B%3CBR%20%2F%3EC13%20the%20total%20of%20the%20sum%20in%20C11%20%2B%20the%20VAT%20in%20C12.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20I%20don't%20know%20what%20formel%20write%20in%20C12%20to%20find%20or%20calculate%20the%2025%25%20of%20the%20sum%20in%20C11%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20trying%20so%20many%20things%20and%20googling%20for%20days%20without%20any%20success%2C%20I%20now%20hope%20so%20much%20anyone%20here%20can%20help%20me.%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20so%20much%2C%3CBR%20%2F%3EPia%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EPS%3A%26nbsp%3B%20I'm%20not%20kidding%3B%20the%20Danish%20VAT%20really%20is%2025%25%20!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1147090%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-1147112%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%2025%25%20of%20the%20sum%20in%20a%20specific%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1147112%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3ELet%20say%20you%20wanna%20calculate%20the%2025%25%20in%20cell%20C13%2C%20do%20the%20following%20%3CBR%20%2F%3E%3DC11*25%25%3CBR%20%2F%3E%3CBR%20%2F%3Ethat%20will%20give%20you%20the%2025%25%20of%20the%20Total%20value%20in%20C11%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1147118%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%2025%25%20of%20the%20sum%20in%20a%20specific%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1147118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F542336%22%20target%3D%22_blank%22%3E%40rakonxx%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20caption%20below%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168542iE5FE138F3D1E8709%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Sorry, but I'm not a native English speaker and I better explain this as simple and graphic as I can: 
My friend has a business and he wants to give his costumers a note he is writing in Excel, showing how much each item they have bought cost, and then the sum without 25% tax, then how much the 25% tax is,  and at the end the sum incl tax.

Let's say the numbers are written in column C:
From C1 to C10 we have a list of the cost of each item,  
C11 shows the sum of C1 to C10 (without 25% VAT) 
C12 shows much much the 25% VAT is 
C13 the total of the sum in C11 + the VAT in C12. 

But I don't know what formel write in C12 to find or calculate the 25% of the sum in C11?

After trying so many things and googling for days without any success, I now hope so much anyone here can help me.  

Thank you so much,
Pia 

PS:  I'm not kidding; the Danish VAT really is 25% !!

2 Replies
Hello,

Let say you wanna calculate the 25% in cell C13, do the following
=C11*25%

that will give you the 25% of the Total value in C11

@rakonxx 

 

See the caption below

clipboard_image_0.png