What I want is if user selcts say Data from combo box in a cellC19 and then enters a number value like 400 into K19 then Cell O19will equal K19*0.2 to give value in O19 else user may enter value in L19 and if so then I want L19*0.5 to then equal O19 say just for example
But I want this for all cases in the combo Box i.e I have 10 cases
How will I do this for all cases..
Also if user enters value in either K19 or L19 is there a way so he can not enter in both just one entry
See attached file
See attached:
I added 2 extra columns to your table to show the respective factors.
Then I used Vlookup() to extract the proper values depending on what was chosen in the dropdown cell and which respective column a number was entered in.
To ensure only one entry made, I used Data|Validation|Custom and entered simple formula...
You may have to copy the formulas and data validation down your table.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks