Forum Discussion

Safi23's avatar
Safi23
Copper Contributor
Feb 23, 2021
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)?    
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Feb 23, 2021

    Safi23 

    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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 23, 2021

Safi23 As a variant:

=LOOKUP(A2,{0,7.35,7.450001},{"Acid","Neutral","Alkaline"})

 

Resources