I'm trying to do a Foot Candle Reading calculation for a lighting assessment. Basically, I need it say "Too Dim" if it's below 0.5, "Too Bright" if it's about 5 and "OK" if it's anything else.
The formula I have in excel is =IF(E6<0.5,"Too Dim",IF(E6>5,"Too Bright","OK"))
I've tried a combination of this:
if(selected(${fcr}"<0.5","Too Dim",if(selected(${fcr}">5","Too Bright","OK"))))
Duplicate question in Survey 123 https://community.esri.com/thread/233754-survey123-if-statements