Forum Discussion
Search for a result in one row and then if the result is x return a Text
Hi can you help please,
How can have search a result in a cell, and only return a specific result, instead of true or false.
Example, if a cell (F5) is equal to 4, the cell where I am using the formula should return x.
Thank you
1 Reply
Hello,
it's hard to answer that without knowing your data layout and your formula. A formula will return what you tell the formula to return.
If you use a formula that returns "True" or "False", you can wrap this formula into an IF statement that returns something else for True or False. For example, if your current formula is =F5=4 and it returns True or False, you can use
=if(F5=4,"x","")
when F5 is equal to 4, the IF formula will return "x".
If that does not help, please post some more context. A sample file would be great.
