Forum Discussion

Jeffern's avatar
Jeffern
Copper Contributor
Nov 28, 2023

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) =...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Nov 29, 2023

Jeffern 

You have to use the double quote character " (Shift+' on my keyboard), not two single quote characters ' next to each other.

And blank is not a valid keyword in Excel. Use the empty string "" (two double quote characters) instead:

=IF(B9="";"";IF(B9="B3";"B2"))

What do you want to return if B9 is not empty and not equal to "B3"? In that case, the formula will currently return FALSE because you don't specify the return value.

Jeffern's avatar
Jeffern
Copper Contributor
Nov 30, 2023
Thank you again for the information. I think I get the gist of it now. I will even try to expand the problem to include B4 changed to B3, then there will be three IF's. I hope I can do it with four parenthesis at he end.
  • Jeffern's avatar
    Jeffern
    Copper Contributor
    Nov 30, 2023
    Sorry to bother you again. When enter exactly what you suggest, I get an error message: The formula contains unknown text. I do not understand it. Any suggestions?
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 30, 2023

      Jeffern 

      Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

      • Jeffern's avatar
        Jeffern
        Copper Contributor
        Nov 30, 2023

        HansVogelaar 

        Hans, the easiest for me would be to attach an excerpt to an email.

        I don't know how to make it available to you via Drop Box or similar. I suppose this is not according to rules to use email

Resources