Results 1 to 3 of 3

[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. #1
    teo
    teo is offline
    New Member
    Join Date
    Apr 2005
    Location
    SF, CA
    Posts
    1

    Default [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. #2
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,765

    Default

    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
    =

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

    [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.
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  3. #3
    Board Regular Todd Bardoni's Avatar
    Join Date
    Aug 2002
    Location
    Rochester, MI USA
    Posts
    3,044

    Default

    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.
    Todd


    "I'm a Data Anlyst(intermediate) and have no idea what it's all about."

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com