Forum Discussion
Need a formul for text
If I enter a value in a cell, I want a text to be generated in another cell. What formula can I use?
You can use the IF function to generate text in another cell based on the value of a cell. Here's an example:
Let's say you want to enter a value in cell A1 and generate text in cell B1 based on that value. If the value is greater than 10, you want B1 to display "High", otherwise, you want it to display "Low".
In cell B1, you can enter the following formula:
=IF(A1>10, "High", "Low")
This formula checks if the value in A1 is greater than 10. If it is, it displays "High". If it's not, it displays "Low". You can modify this formula based on your specific requirements.
Let's say you want to enter a value in cell A1 and generate text in cell B1 based on that value. If the value is greater than 10, you want B1 to display "High", otherwise, you want it to display "Low".
In cell B1, you can enter the following formula:
=IF(A1>10, "High", "Low")
This formula checks if the value in A1 is greater than 10. If it is, it displays "High". If it's not, it displays "Low". You can modify this formula based on your specific requirements.