I can’t seem to understand where’s the issue with the Syntax here:
=if(B21<0, "Missing", ""), if(B21=0, "", ""), if(B21>0, "Too much", "")
i tried many variations, commas, semicolons etc., but it works only if there’s only 1 “if” sentence
There is also the IFS function
=IFS(B21<0,"Missing",B21=0,"",B21>0,"Too Much")
Or, using the IF function, you only need to check if <0 and if >0. No need to check for =0 because if it is not <0 or >0 then it has to be =0.
=IF(B21<0,"Missing",IF(B21>0,"Too Much",""))
There is also the IFS function
=IFS(B21<0,"Missing",B21=0,"",B21>0,"Too Much")
Or, using the IF function, you only need to check if <0 and if >0. No need to check for =0 because if it is not <0 or >0 then it has to be =0.
=IF(B21<0,"Missing",IF(B21>0,"Too Much",""))
I can’t seem to understand where’s the issue with the Syntax here:
=if(B21<0, "Missing", ""), if(B21=0, "", ""), if(B21>0, "Too much", "")
EDIT, Nevermind, found the solution - for “if-false” you’d add the next if statement
Syntax Error in Numbers
