Hi. I hope I placed this thread in the correct place, I looked around and thought this forum was the most appropriate. On to my question.

I have a number of formulas I would like to create, I know all the variables of the formula but I don't know how they interact with each other to create the end result. Ideally I'm looking for a program where I can input the variables and have it work it out automatically however if someone could explain or link me to something that explains how to efficiently create a formula manually that would also work.

An example of the formula is;

A (Starting Number) +-*^/ B,C,D,E,F = G (End Result)

A is my starting number, 100 for example. B to F are the variables which are percentages which add, multiply, divide, subtract / whatever else to create G which is the final result. What I need to know is how B to F interact with each other since so I can change A at will in a spreadsheet.

Many Thanks,

Voland