Adjustable total

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

@Tris69 

Enter the following formula in E7:

 

=C7/C$14*E$14

 

Fill down to E12.

You are a Hero THank you Thank you Thank you

@Hans Vogelaar