How do I put values on an adjacent cell depending on what a choose from a drop down box. So if I choose 5, it will be 5 on a separate cell and if I choose 3, it will be three and if N/A it will be 5?
How do I put values on an adjacent cell depending on what a choose from a drop down box. So if I choose 5, it will be 5 on a separate cell and if I choose 3, it will be three and if N/A it will be 5?
What cell is the drop down in? What values can be selected in the drop down box? Where do you want the result? What values do you want for each of the values picked in the drop down?
If it's just a few, you could use IF. But, if it's a lot you might want to use a LOOKUP table.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Lets say A1-A5 and has dropdowns for 3, 0 and N/A. I want the N/A to be read as 3 so it doesn't affect the percentage.
Formula:Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks