Forum Discussion
Use of IF
=IF(B9=0;0;IF(B9='B3'='B2';IF(B9='B4'='B3))) I get error messages If a field='B3', I want to replace it with 'B2', if a field ='B4', I want to replace it with'B3*The fields are either blank(emty) =...
Thank you for your help. I do not know the syntax in excel well. At the end I would enter a double quote. Actually, there is an addition to this problem: If b9=“” B4»»; “B3””,””. This problem is a playlist in tennis which i recurring twice a year.
This time. you're using "curly quotes" ”” instead of straight quotes "".
And you definitely shouldn't use »» in Excel.
Also, you forgot the parentheses and a semicolon.
=IF(B9="";"";IF(B9="B3";"B2";""))Alternatively, slightly shorter:
=IF(B9="B3";"B2";"")