What is the use of the star before AND in if statement

Re:

Please Login or Register  to view this content.

The asterisk (*) is Excel's muliplication operator. In that formula, it is multiplying the result of the first test (P13>O13) by the results of the second test AND(C13>=75). Each of those tests return a TRUE/FALSE value. By applying an arithmetic operator (+, -, *, /), they are converted to 1 and 0, respectively. If they are both TRUE....then 1*1=1. In the test section of an IF formula, TRUE and 1....FALSE and 0....are interchangable.

However.....a better formula would be this:

Please Login or Register  to view this content.

Does that help?

Originally Posted by arfanvilla

=IF((P13>O13)*AND(C13>=75),P13,"")

What is the use of the star before AND.

thanks

What are trying to do?

You probably want:

=IF(And(P13>O13,C13>=75),P13,"")

which means if P13 > O13 and C13>-75, then return P13 else leave blank.