AnsweredAssumed Answered

Survey123 IF statements

Question asked by deleted-user-q9dwpTdLbTzp on May 14, 2019
Latest reply on May 14, 2019 by kr1337

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

 

Is this possible or too complicated?

Outcomes