May 22, 2019
Good Evening Everyone,
Not sure if anyone can help or point me in the right direction,
I'm new to Excel Formulas etc etc.
OK So i'm trying to create a type of calculator in excel based on certain figures?
e.g so if i type say 100, I want excel to populate a solution e.g. 50+50. But the solution can only be based on certain figures e.g. 50+50 or 80+20, don't want it to populate say 1+99 or random figures, has to based on figures that I have told it to .e.g only use 50,20,10,30??
Any help would be appreciated,
July 16, 2010
Can you please upload a sample Excel file containing some examples? I'm not sure where this 50+50 or 80+20 information is coming from. Is it other cells, or just random values that add up to 100.
Please provide enough examples so you cover every scenario.