# Software

## Question

Locked

### VLOOKUP adding another cell to reference and calculate from

By ·
I have created three cells in an Excel 2003 worksheet.

The cells are Named:
Cell1 = PERIOD
Cell3 = INSTALMENT

PERIOD is a drop down list containing a range of dates:

01/07/2009 - 30/06/2010
01/01/2009 - 31/12/2009

PREMIUMBASE is a dollar amount which is manually entered

INSTALMENT will calculate a dollar percentage of PREMIUMBASE dependant on which date range is chosen in PERIOD

I have created a VLOOKUP table as:

COLUMN 1 COLUMN 2
01/07/2009 - 30/06/2010 2.5%
01/01/2009 - 31/12/2009 3.5%

An example result would be:

PERIOD 01/07/2009 - 30/06/2010
INSTALMENT \$25.00 (provided from VLOOKUP table)

The current formula, which is working well, is:

What I would now like to do is add a fourth cell Named FEE

This cell would consist of a simple YES/NO drop down list.

If YES is chosen in this fourth cell the formula will return the given percentage as per the example above.

If No is chosen in this fourth cell the formula will return \$0.00 in INSTALMENT

How can I get this to work correctly as I am at a loss to work it out!!

Any help will be most appreciated.

Regards

Ianmax49

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

.

Collapse -

### Use IF

Pretty simple to use for a simple yes or no question. The formula would look something like: =IF(FEE="Yes",((PREMIUMBASE)*VLOOKUP(PERIOD,INSTALMENT,2)),0)

The first portion (before the comma) is the logical test, the second part (after first comma but before second) is the value you want if the logical test is true, the last part is the value you want to see if the logical test is not true.

Hope this helps!!

## Related Discussions

• 1

Bumble-bee ·

• 1

zlzpqx ·

• 1

ITguy1986 ·

• 1

#### by which software I can make my PD portable?

webtechexprt ·

• 8

#### what is the best chatbot software for small business?

nathanlohey ·