Formula help.

**jfrago** · 04-13-2008, 09:32 PM

Good morning. I'm a new user trying out some advanced stuff in Excel, and I'm a little way over my head here. A little (or a lot) of help is greatly appreciated.

I have 3 tables:
Lower_Limit, Upper_Limit, TFPool

What is the excel formula equivalent of this:
TFPool is equal to the average value of Lower_Limit and Upper_Limit multiplied by (TFPool Multiplier).

TFPool Multiplier=10% if Upper_Limit>100000, else 5%

I'm using Excel 2007.

Thanks!

**darkyam** · 04-13-2008, 09:49 PM

Assuming these are in columns A:C, C2 could be =IF(B2>100000,.1,.05)*Average(A2:B2)
Please read the forum rules and post a more descriptive title on your next post. The more descriptive your title is, the easier it will be for someone who has a similar issue to find an answer when they search through the posts.

**jfrago** · 04-13-2008, 10:29 PM

Thanks, darkyam. I was trying to come up with a more descriptive title, but words failed me.

A little more explanation with my situation:
1. I used the Insert->Table function in Excel 2007. Apparently if you change a variable in a cell within this table, it affects all cells.

2. This causes a problem because I want to give a condition: if upperlimit>=100000, then tfpool multiplier is 10% else 5%

3. Ultimately, i want to have a situation where if a given value x falls within the range between upperlimit and lowerlimit, value y is checked and the result is given. value y is a percent. (hope am making sense).