[b]Using an asterisk as "IF" function[/b]

This is a discussion on [b]Using an asterisk as "IF" function[/b] within the Excel Questions forums, part of the Question Forums category; I have seen an asterisk used in the same way as an IF function. I am trying to simplify imbedded ...

1. [b]Using an asterisk as "IF" function[/b]

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.

2. teo,

WELCOME to the Board ! ! !!!

the sheet here may be the proof of what you think to be the truth
in such cases it seems good to me to try out with very simple examples

kind regards,
Erik

******** ******************** ************************************************************************>
 Microsoft Excel - Map1.xls ___Running: xl2002 XP : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B1D1B2D2B3D3 =

A
B
C
D
E
F
1
-400 144
2
00 004
3
11 023

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

3. The asterisk does not replace an IF but there are different ways to write a formula and to get the same result. For example, instead of nesting a bunch of IF statements together, most of the time you can use VLOOKUP. As an experiment type:-

=TRUE in a cell.

Now type:-
=1*TRUE

Now type:-
=0+TRUE

Now type:-
=--(TRUE)

Now, with all of these examples, replace TRUE with FALSE. Come back with any questions you may have.

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•