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 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.
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?
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?
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
You can attach a file to a private message. Click on my user picture.
