Adjustable total

%3CLINGO-SUB%20id%3D%22lingo-sub-1758091%22%20slang%3D%22en-US%22%3EAdjustable%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758091%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20the%20last%20column%20adjustable%20so%20where%20the%205800%20i%20want%20to%20add%20my%20own%20weight%20example%206000%20into%20E14%20and%20what%20to%20know%20the%20various%20weights%20of%20the%20ingredients%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20or%20function%20i%20can%20do%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1758091%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1758293%22%20slang%3D%22en-US%22%3ERe%3A%20Adjustable%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F824704%22%20target%3D%22_blank%22%3E%40Tris69%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20E7%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DC7%2FC%2414*E%2414%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down%20to%20E12.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

hello 

 

I want to make the last column adjustable so where the 5800 i want to add my own weight example 6000 into E14 and what to know the various weights of the ingredients

is there a way or function i can do this

2 Replies
Highlighted

@Tris69 

Enter the following formula in E7:

 

=C7/C$14*E$14

 

Fill down to E12.

Highlighted

You are a Hero THank you Thank you Thank you

@Hans Vogelaar