Ask Your Question

When using an =IFS statement Some of the results display N/A Even though it looks like there are no problems

asked 2020-04-29 21:36:01 +0100

Inve1963 gravatar image

updated 2020-08-05 00:55:11 +0100

Alex Kemp gravatar image

The Statement: =IFS(D2<5 AND(F2-E2<2) ,"Easy",D2>=5 OR(D2<10) AND(F2-E2>=2 OR(F2-E2<=4)),"Semi hard",D2>=10 AND(F2-E2>4 OR(F2-E2<6)),"hard",D2>=11 AND(F2-E2<9),"Sucks",D2>=100,"How?")

One of the N/A output Column info is D2=4 F2=8 E2=4

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-04-29 23:26:10 +0100

m.a.riosv gravatar image

I think the error is with how the formulas are build D2<5 AND(F2-E2<2) -> AND(D2<5;(F2-E2)<2)) i guess, using explicit parentheses to do it more secure, avoiding an undesirable order with the calculations with the implicit precedence.

AND() function Help

edit flag offensive delete link more


Have a nice day it worked

Inve1963 gravatar imageInve1963 ( 2020-04-30 01:52:49 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-29 21:36:01 +0100

Seen: 51 times

Last updated: Apr 29 '20