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


A

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top