Differance in IiF() FUNCTION AND Case Statement???

Question

Differance in IIF() FUNCTION AND Case Statement??? Which one is faster???

Sanwar Ranwa · Answer

IIF is simplify case statement iif is faster than case statement

Vipin Mittal · Answer

thax ur answer is really helpful....

Altaf Ansari · Answer

The switch statement is easy to edit as it has created the separate cases for different statements whereas, in nested if-else statements it become difficult to identify the statements to be edited. Key Differences Between if-else and switch Expression inside if statement decide whether to execute the statements inside if block or under else block. On the other hand, expression inside switch statement decide which case to execute. You can have multiple if statement for multiple choice of statements. In switch you only have one expression for the multiple choices. If-esle statement checks for equality as well as for logical expression . On the other hand, switch checks only for equality. The if statement evaluates integer, character, pointer or floating-point type or boolean type. On the other hand, switch statement evaluates only character or a integer datatype. Sequence of execution is like either statement under if block will execute or statements under else block statement will execute. On the other hand the expression in switch statement decide which case to execute and if you do not apply a break statement after each case it will execute till the end of switch statement. If expression inside if turn outs to be false, statement inside else block will be executed. If expression inside switch statement turn out to be false then default statements is executed. It is difficult to edit if-else statements as it is tedious to trace where the correction is required. On the other hand it is easy to edit switch statements as they are easy to trace.