Feb 23 2021 05:55 AM
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)?
Feb 23 2021 06:18 AM
SolutionLet'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.
Feb 23 2021 07:04 AM
Feb 23 2021 07:13 AM
Feb 23 2021 07:31 AM
=IF(AND(C8="Macrocytic",C9= "Hyperchromic"), "Iron Deficiency", IF(AND(C8="...", C9="..."), "...", "..."))
But if you have many combinations, it would be better to create a lookup table. We'd need to have detailed information if you want help with that.
Feb 23 2021 07:52 AM
Feb 23 2021 08:00 AM
In C10, confirmed with Ctrl+Shift+Enter:
=INDEX(Sheet2!$C$2:$C$6,MATCH(1,(Sheet2!$A$2:$A$6=C8)*(Sheet2!$B$2:$B$6=C9),0))
Feb 23 2021 06:18 AM
SolutionLet'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.