If statements

123
2
05-14-2019 07:09 AM
Highlighted
New Contributor

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"))))

Reply
0 Kudos
2 Replies
Highlighted
MVP Honored Contributor

Is this for Survey123? Please add some tags or text indicating what software you're asking about. Also this space is for asking questions about GeoNet itself. Please move this to the appropriate space

Reply
0 Kudos
Highlighted
Moderator

Duplicate question in Survey 123 https://community.esri.com/thread/233754-survey123-if-statements

Community Moderator, Esri Community Team.