Logical Operators upgrade.
Pages:
1
Actions
Choose an action
Print
#1 by liltbrockie on 14 Nov 2018
Hi there... nested IF's are great but can we have something a little more elegant?
1. Can we allow for AND, OR operators in IF statements?
eg:
IF(1>0 AND 2>2,10,-10) retursn -10
2. Can we have CASE statements?
eg:
CASE(
X=1;100;
X=2;200;
)
liltbrockie
#2 by mcbee on 14 Nov 2018
hi
Quote
IF(1>0 AND 2>2,10,-10) retursn -10
try IF(AND(1>0,2>2),10,-10)
mcbee
mcbee
#3 by liltbrockie on 14 Nov 2018
Did not know this.
Add it as an example to the help manual!
liltbrockie
#4 by mcbee on 14 Nov 2018
hi
it is basic excel formulea.
mcbee
mcbee
#5 by liltbrockie on 15 Nov 2018
OK great..! Add THAT to the manual too! Even better.
liltbrockie
#6 by liltbrockie on 15 Nov 2018
.....and I see THAT is already in the manual...Jolly good carry on as you were!
liltbrockie
Pages:
1
Actions
Choose an action
Print
Desktop View
Hello Guest
Home
Recent Posts
Register
Login
Mobile View