Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture

[Astanza]

In a simple table, I have these four values representing these four
%'s (0%, 3%, 6% & 9%)

0 0%
1 3%
2 6%
3 9%

In a target cell (D1) I want to reference the drop down menu cell just
to the left (C1) which has values of either 0 (default), 1, 2, 3.

ItemName (A1) Base Price(B1) Value of (0, 1, 2 or 3)
(Cell C1) Formula Target Cell (Cell D1)

if "1" is shown, I would like a formula that multiplies the Base Price
(cell B1) times the reference of 3%
if "2" is shown, I would like a formula that multiplies the Base Price
(cell B1) times the reference of 6%

Finally, I would like to add an (ISBLANK) so that the Target cell
shown nothing if there is not an entry in A1

 

[Pete_UK]

Try this in D1:

=IF(A1="","",B1*C1*3/100)

Hope this helps.

Pete