3 variable formula

**zballz** · 01-18-2011, 12:55 PM

I thought this was going to be quite simple, but cannot seem to find a way to get this to work. I hope someone here is able to help out.

What I am looking for is simply a formula to do this:

Length A : ____
Length B : ____
Area : ____

(calculating the area of a rectangel)

Now, this is simplified for the example, and the formula is simply A*B=C. But basically I want to be able to input two out of the three variables, and the third should then be calculated, appearing in the proper cell... And if possible you could then keep changing in the variables and get the 'new' results...

Is this even possible??

**MarvinP** · 01-18-2011, 01:58 PM

Hi zballz and welcome to the forum,

Lets think about this... You have formulas in each of youir three cells. You then put a number in one of these cells. This would then overwrite the formula with a number,

but you want the formula for the next question.

You should create 3 different rows for your problem.
1. Given A and B Calculate Area C
2 Given Area C and Length A calculate B
3. etc

The last cell is the only one that has the equation in it. The first two cells simply have values.

I hope this makes sense.

You could actually do what you want using VBA, with an Event Macro. It would understand what value's cell you put the last number in and calculate the two other values. It would use a different formula if you change one of the lengths vs the Area. I think the above 3 lines are a much easier answer than learning VBA, but we are here to help.

3 variable formula

LinkBack

Thread Tools

Rate This Thread

Display

3 variable formula

Re: 3 variable formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions