alexanderR
New member
- Sep 15, 2008
- 7
- 0
- 1
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!
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!