I am a Novice excel user, sorry if this question has been ask and answer many times before. Nothing I have read seem to help me.
I am trying to build a template,with a dropdown menus ( I have the menu part down) depending on the choice in the dropdown the result will populate in the column to the right.
example: E6 will have choice of .05min - 6.5mh , F6 I want it to enter a formula like =sum(C6*what ever the choice is) so if I choose 5min I want it to populate =Sum(C6*.083)
Thank you in advance.
Bookmarks