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!
Mark
Perfect! thank you!!
1 Like