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,
Regards
Hits
Hi Hitesh,
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.
Thanks,
Mynda
Hi Hitesh,
Maybe you look for something simple like this example?
Frans
