User input Auto multiplies by constant

vikhound,

Obviously, disregard my post. For some reason, I must have thought I was in the General section of the forum.

Clearly, you intended to get a VBA solution.

Ok so I attached the file to this forum reply. Just to resummarize;
In this file I need to create reference cells with fixed values into C2, D2, and E2 respectively. Then I want the user to be able to enter values into the corresponding columns (C5, D5, or E5 onwards) and have it automatically multiply by C2, D2, or E2. So if a user wants to edit the RAD ingredient in product C, all they do is input a number into the corresponding column C and it automatically multiplies by the value in C2. Also, Can you tell me how to increase the number of columns in case new ingredients need to be added?
Thanks alot for taking trouble,
Vik