On the attachment (which i hope has worked), i have a sheet i have added a Combo Box too with a drop down menu in, with two options, Y and N
Now in another cell, H24, i want to use the chosen option in a formula, to say that if Y is chosen then the value in H24 is to be 4.38, but if N is chosen i want the value in H24 to show as 0
How can i do this plz? i have looked on google and tried but although the combo box is drawn over F6, the SUM formula didnt seem to pick up any values entered in F6, so i assume it has to somehow link to the combo box itself and not the cell it is over? I cant see anywhere either to give that combo box a name in order to link it?
any help much appreciated, thanks!
Bookmarks