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