Forum Discussion
Solved
IF Function
How would I use the IF function or any other function to make the response acid (<7.35) Neutral (7.35-7.45) and Alkaline (>7.45)?
Let's say the number is in A2.
In another cell, say B2:
=IF(A2="","",IF(A2<7.35,"Acid",IF(A2<=7.45,"Neutral","Alkaline")))
This can be filled down if required.
Let's say the number is in A2.
In another cell, say B2:
=IF(A2="","",IF(A2<7.35,"Acid",IF(A2<=7.45,"Neutral","Alkaline")))
This can be filled down if required.
Thank you so much! you saved me so much time!