Survey123 IF statements

[deleted-user-q9dwpTdLbTzp]

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?

[BrandonArmstrong]

Hi Travis,

Have you considered using a constraint with constraint messages to restrict input to the values you specified? 

For instance, you can place the following in the Constraint column 

.>0.5 and .<5

and then also provide a Constraint message that states "Value needs to be between 0.5 and 5"

Please refer to the attached XLSForm and linked documentation as an example...

Survey123 - Contraints

Best,

Brandon

[KassandraRodriguez]

if(${fcr} < 0.5, 'Too Dim', if(${fcr} > 5, 'Too Bright', 'OK'))

Try this and I think it would be helpful if you made fcr a decimal type