Why is the following formula not working?
=IFS($B$29=(OR(1;4;10));8310;$B$29=6;9510;$B$29>0;"")
When $B$29
is 10
, should display 8310
, but becomes the empty result.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityWhy is the following formula not working?
=IFS($B$29=(OR(1;4;10));8310;$B$29=6;9510;$B$29>0;"")
When $B$29
is 10
, should display 8310
, but becomes the empty result.
or if you really need IFS
solution:
=IFS(OR($B$29 = 1 ;
$B$29 = 4 ;
$B$29 = 10); 8310;
$B$29 = 6 ; 9510;
$B$29 > 0 ; )
try:
=IF(OR($B$29 = 1 ;
$B$29 = 4 ;
$B$29 = 10); 8310;
IF( $B$29 = 6 ; 9510;
IF( $B$29 > 0; ; )))
syntax of OR
needs to be in this format: =OR(B29=1; B29=4; B29=10)
=IFS(OR(B29=1;B29=4;B29=10);8310;$B$29=6;9510;$B$29>0;"")
. I will accept the solution then.
– klor
Sep 10 '18 at 9:53