Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Normal
I have a drop down menu with Electricity, Gas and Coal as the options.I then want other cells to have certain figures based on what fuel source has been chosen.So in lay mans terms i would like cell C7 to =C14 IF C3 ='Electricity' OR =C21 IF C3 = 'Gas' OR = C28 IF C3 = 'Coal'C14 having the figure for Electricity, C21 having the figure or Gas...etcC3 is the drop down menu cell with electricity, gas and coal.I would really appreciate some help with this. Thanks!
I have a drop down menu with Electricity, Gas and Coal as the options.
I then want other cells to have certain figures based on what fuel source has been chosen.
So in lay mans terms i would like cell C7 to =C14 IF C3 ='Electricity' OR =C21 IF C3 = 'Gas' OR = C28 IF C3 = 'Coal'
C14 having the figure for Electricity, C21 having the figure or Gas...etc
C3 is the drop down menu cell with electricity, gas and coal.
I would really appreciate some help with this. Thanks!
