If statements

348
2
05-14-2019 07:09 AM
deleted-user-q9dwpTdLbTzp
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"))))

0 Kudos
2 Replies
KenBuja
MVP Esteemed 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

0 Kudos
by Anonymous User
Not applicable