Discussion Using list function as a parameter in a budget calculation in Excel
https://techcommunity.microsoft.com/t5/excel/using-list-function-as-a-parameter-in-a-budget-calculation/m-p/924525#M42506
<P>Hi!<BR /><BR />I am trying to use a list function (enabled from data verification) as a variabel in a budget. Hence my ambition is to use the list function as the fluctation in volumes for a product so we can create different scenarios depending on the sales volumes coming year.<BR /><BR />If the product sells 5 % less, the list function can be used to set the value of 0.95 and then the estmiated number budgeted for the product shoudl change to 5 % less. However I can't make it work even though I atleast think I use the correct formating of a multiplication, hence =A9*B27 in this case.<BR /><BR />Is it impossible to use list as a input source for a formula in Excel?<BR /><BR />Thnx for all the help!</P>Mon, 21 Oct 2019 20:01:53 GMTJonasPonas2019-10-21T20:01:53ZUsing list function as a parameter in a budget calculation
https://techcommunity.microsoft.com/t5/excel/using-list-function-as-a-parameter-in-a-budget-calculation/m-p/924525#M42506
<P>Hi!<BR /><BR />I am trying to use a list function (enabled from data verification) as a variabel in a budget. Hence my ambition is to use the list function as the fluctation in volumes for a product so we can create different scenarios depending on the sales volumes coming year.<BR /><BR />If the product sells 5 % less, the list function can be used to set the value of 0.95 and then the estmiated number budgeted for the product shoudl change to 5 % less. However I can't make it work even though I atleast think I use the correct formating of a multiplication, hence =A9*B27 in this case.<BR /><BR />Is it impossible to use list as a input source for a formula in Excel?<BR /><BR />Thnx for all the help!</P>Mon, 21 Oct 2019 20:01:53 GMThttps://techcommunity.microsoft.com/t5/excel/using-list-function-as-a-parameter-in-a-budget-calculation/m-p/924525#M42506JonasPonas2019-10-21T20:01:53ZRe: Using list function as a parameter in a budget calculation
https://techcommunity.microsoft.com/t5/excel/using-list-function-as-a-parameter-in-a-budget-calculation/m-p/925862#M42528
Could you attach an example Excel file or a screenshot?<BR /><BR />Are you trying to reference a drop down data validation cell containing a list of percentages?Tue, 22 Oct 2019 03:37:30 GMThttps://techcommunity.microsoft.com/t5/excel/using-list-function-as-a-parameter-in-a-budget-calculation/m-p/925862#M42528Wyn Hopkins2019-10-22T03:37:30Z