Drop down lists

Hi

Let's say that in G6 exists number 5.

In drop down list, if someone choose 5, what do you want to happens?

Someone inputs in G6, "5" and the same time G7:G10 are empties? Correct?

In F1 is your Validation list with percedange numbers(5%;10%....etc)

Then try

=SUM(G6:G10)+SUM(G6:G10)*F1

When you don't know something, it's not silly to ask! It's too cleaver.

If I understand correctly, you don't want the sum of the new values but just the new values? If you wish to actually change the values in the cells (C6:G10), that will require you to use a Macro or VBA. Or you could just set up a second table as I did in Fotis' workbook.
Take a look at this workbook and let me know if you have any questions.

Edit: If you need them to actually change within the cells, let me know and I'll show you how to create that macro.

Okay, what happens after the first change? Does it go back to the original number for calculations?
For example, if the number in G6 was 10 and you put in 70%, then G6 would become 7. Now what happens if you change the value in F1 ot 50%, should the value in G6 become 3.5 or 5?

Assuming it doesn't go back to the original number, put this code in the spreadsheet module

Please Login or Register  to view this content.

C1 would be the cell where you are entering the percentage. Adjust as necessary.
Right click on the spreadsheet tab and "View Code" Then simply paste the code in and close the VBA editor.

@ ChemistB,

You and Fotis1991 have done a great job so far. However, I am a little bit concerned that a user will get confused if he/she enters a value say ~ 100 ~ into a Cell, and the Data entered shows as ~ 60. Another point is that if a typo is made while entering a value, will any user be able to realise that it was indeed a mistake, since another value will appear in that Cell?

@ floricita,

May I suggest that you reconsider your intentions and see if the modified attached WorkBook from Fotis1991 and ChemistB is not good enough?

Hi Winon,
I agree, that it would get confusing because you'd lose track of what you originally entered.
To your point however, the values would not change upon entering in the spreadsheet I created. They would only change when the user changes the cell containing the Percentage.