lundi 6 juillet 2015

Excel IF statement from drop down meni.

I am trying to create an IF statement from a drop down menu where I have made the options Yes or No.

I have gone for: =IF(B2=''Yes'',D5,0) This is giving me an error.

However when I try: =IF(B2=Yes,D5,0) it says I have used the wrong data type. Can anyone help?

Thank you

Aucun commentaire:

Enregistrer un commentaire