Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I am currently trying out this formula:
Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!")
Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is EITHER = "Bob G" OR "George G" and then return "This formula does not work!" when the value is equal to Donald X and George X or essentially any other value at all![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
However, my formula does not work at the moment and it gives me an error. I have never used OR before in a formula, so I think I may have this messed this one up?
Can somebody please help me?
THank you!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I am currently trying out this formula:
Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!")
Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is EITHER = "Bob G" OR "George G" and then return "This formula does not work!" when the value is equal to Donald X and George X or essentially any other value at all
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
However, my formula does not work at the moment and it gives me an error. I have never used OR before in a formula, so I think I may have this messed this one up?
Can somebody please help me?
THank you!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)