If statement

Hello, Can someone help with an if statement? If “column a” is under 15 return “Under”, over 15 “Over” equal 15 “At” , but if no value would like for it to return a “-”. I have done research and have gotten it to work on some cells except the ones that are blank. The cells that are blank returns a “Under” and would like a “-”.
Thank you!

Hi @Normabranscum - try the following:

IF({column a} > 15, "Over", IF({coulmn a} = 15, "At", IF({column a} < 1, "-", "Under")))

Hope this helps!

Perfect! thank you!!

1 Like