Home

Using list function as a parameter in a budget calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-924525%22%20slang%3D%22en-US%22%3EUsing%20list%20function%20as%20a%20parameter%20in%20a%20budget%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-924525%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20use%20a%20list%20function%20(enabled%20from%20data%20verification)%20as%20a%20variabel%20in%20a%20budget.%20Hence%20my%20ambition%20is%20to%20use%20the%20list%20function%20as%20the%20fluctation%20in%20volumes%20for%20a%20product%20so%20we%20can%20create%20different%20scenarios%20depending%20on%20the%20sales%20volumes%20coming%20year.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20the%20product%20sells%205%20%25%20less%2C%20the%20list%20function%20can%20be%20used%20to%20set%20the%20value%20of%200.95%20and%20then%20the%20estmiated%20number%20budgeted%20for%20the%20product%20shoudl%20change%20to%205%20%25%20less.%20However%20I%20can't%20make%20it%20work%20even%20though%20I%20atleast%20think%20I%20use%20the%20correct%20formating%20of%20a%20multiplication%2C%20hence%20%3DA9*B27%20in%20this%20case.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20impossible%20to%20use%20list%20as%20a%20input%20source%20for%20a%20formula%20in%20Excel%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThnx%20for%20all%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-924525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-925862%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20list%20function%20as%20a%20parameter%20in%20a%20budget%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-925862%22%20slang%3D%22en-US%22%3ECould%20you%20attach%20an%20example%20Excel%20file%20or%20a%20screenshot%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAre%20you%20trying%20to%20reference%20a%20drop%20down%20data%20validation%20cell%20containing%20a%20list%20of%20percentages%3F%3C%2FLINGO-BODY%3E
Highlighted
JonasPonas
Occasional Visitor

Hi!

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.

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.

Is it impossible to use list as a input source for a formula in Excel?

Thnx for all the help!

1 Reply
Could you attach an example Excel file or a screenshot?

Are you trying to reference a drop down data validation cell containing a list of percentages?
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies