•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to Change Values Based on another Cell's Values?
So basically, I'm trying to figure out how to make a cell have a certain text value depending on the number value of another cell. An example would be if B2 is less than 10, the text should say "hi", if it's between 11 and 20, it should say "hello", and if its above 21, it should say "bye". I've already tried IF statements within each other, but it wouldn't work properly. Any ideas or suggestions would be greatly appreciated.
Edit: I found the answer, thanks to everyone who commented :)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#cloud-based spreadsheet applications
#Excel
#cell value
#text value
#number value
#IF statements
#conditional formatting
#logical operators
#change values
#B2
#value comparison
#between 11 and 20
#text output
#less than 10
#greater than 21
#text conditions