•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?
Our take
Are you looking to dynamically change a cell's text based on the value of another cell? For instance, if cell B2 holds a number less than 10, you want it to display "hi." If the number is between 11 and 20, it should show "hello," and for values above 21, it should say "bye." While nested IF statements seem like an option, they can be tricky. Fortunately, there are more effective ways to achieve this. Let’s explore some solutions that will simplify your spreadsheet experience.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [link] [comments]
- How do you write an IF formula that changes the value based on which range, out of two ranges, the original value fell in?I'm entering number values in Column A and I want Column B (where I'm inputting the formula) to populate either a 1 or a -1 based on which range (of two ranges) the value in Column A falls within. The conditions are: If Column A value is between 1-8, then Column B will be 1. If Column A value is between 9-21, then Column B will be -1. If Column A value is outside the two ranges (below 1 or above 21), then Column B can/should say something like FALSE. The formulas I've tried so far (and which failed) are: =IF(OR(AND(A2>=1,A2<=8),1)AND(A2>=9,A2<=21),-1) =IF(AND(A2<=1,A2>=8),1)OR(AND(A2>=9,A2<=21),-1)) Thank you in advance for all of your suggestions/help. submitted by /u/LifeisSuperFun21 [link] [comments]
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