Trying to create a reference range with greater than and equal too

[Pandorom]

I'm very new to using excel, so I am confused.. I am trying to make a number of reference ranges that tell if the value is high or low. So an example would be the reference range is 136 to 145. I would like to be able to put in a number lower and it say low or if its above 145 then it would say high. I figured out how to just do one, =IF(B2<136,"Low",""), but is there away to add to the formula to do both? I feel like it is probably very simple but I don't know.

Also are you able to code a cell to change color in response to the value being higher or lower?

 

[myall_blues]

You can 'nest' IF statements together, so for your example:

=IF(B2<136,"Low",IF(B2>145,"High",""))

Note that while there is no effective limit to how deep this nesting can go, my general rule of thumb is to not go beyond about three or four levels of nesting as the formulas become too complex to manage. Other methods are available for those situations.

For the colour coding, have a look into 'Conditional formatting'.

 

[myall_blues]

To add, since you're using 365 you can also use the IFS formula

=IFS(B2<136,"Low",B2>145,"High",TRUE,"")

 

[Pandorom]

Thank you that is exactly what I needed

 

[myall_blues]

You're welcome - glad we could help. Welcome to Mr Excel.