Nested IF with "greater than"

Help Center Get Answers
1

Hello!
I have an equation that works perfectly in Excel but I cant get to work in Knack - it doesn’t seem to like it when I use the > (greater than) symbol.

Here’s the equation just using fixed numbers, and as you can see there is an equation output that indicates it will work ok.
image

However, when I put in the > symbols where I would naturally put them in Excel (and which are pretty essential to have the correct output!), it suddenly doesn’t work any more:

image

I’ve tried putting brackets around the symbol and number - eg ==(>1.5)?1 but its still not working.

Any ideas anyone? (The resulting numbers will then be used to provide conditional formatting or icons inside a table)

Many thanks!

2

Hi @Lesley

I think the operator should be >= not ==>

==> is not a valid operator :star_struck:

3

Ah, OK, that is accepted as a valid equation, so appears to work in theory - I will test with some actuals shortly. (I thought the double = sign was an integral part of the IF statement set up, hence putting the > after that, but clearly not :upside_down_face:)
Once again, thanks for your help Carl.

1 Like
4

Glad to be of help :+1::rocket: