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?
=B2
, or=ISTEXT(B2)
?