sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
I have a formula but I'm not sure how to write "text" into it.
For example in cell A1 if text appears I want it to result in the answer in B2. for example"
=if(A1=text,1,2)
The use of the word "text" clearly is wrong so must be pretty simple to fix?
For example in cell A1 if text appears I want it to result in the answer in B2. for example"
=if(A1=text,1,2)
The use of the word "text" clearly is wrong so must be pretty simple to fix?
glad you solved your problem.
