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
%'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