top of page

HOW TO MAKE NESTED IF STATEMENTS




So I randomly asked ChatGPT to make me an equation.


I have a ton load of PBA stats and I want to use it for good.


And this is the first time I am using this term and in some ways, this makes ChatGPT even cooler because if I am just going to google this, I might not even know what I'm looking at.


So, here it is.



 

=IF(AND(A1>=5, A1<=9), 3, IF(AND(A1>=1, A1<=4), 1, ""))


Assuming the data you want to check is in cell A1, this formula will first check if the data is between 5 and 9 using the AND function. If it is, it will return a value of 3. If not, it will move on to the next IF statement, which checks if the data is between 1 and 4. If it is, it will return a value of 1. If the data is not within the specified ranges, the formula will return an empty string.


You can adjust the cell reference as needed to apply the formula to your desired range of data.





bottom of page