Forum Discussion
Jeffern
Nov 28, 2023Copper Contributor
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) =...
Jeffern
Nov 30, 2023Copper Contributor
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
Nov 30, 2023Copper Contributor
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?
- HansVogelaarNov 30, 2023MVP
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?
- JeffernNov 30, 2023Copper Contributor
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
- HansVogelaarNov 30, 2023MVP
You can attach a file to a private message. Click on my user picture.