I have seen an asterisk used in the same way as an IF function. I am trying to simplify imbedded functions that include several IF / AND / OR functions.
Question: Will Example 1 always yield the same result as Example 2? Is this 'shortcut' going to provide any unwelcome surprises?
Example 1: =MIN(-SUM(F74:F76),F71)*(F71>0)
Example 2: =IF(F71>0,(MIN(-SUM(F74:F76),F71)),0)
Many thanks.
Question: Will Example 1 always yield the same result as Example 2? Is this 'shortcut' going to provide any unwelcome surprises?
Example 1: =MIN(-SUM(F74:F76),F71)*(F71>0)
Example 2: =IF(F71>0,(MIN(-SUM(F74:F76),F71)),0)
Many thanks.