This site is supported by the advertisements on it, please disable your AdBlocker so we can continue to provide you with the quality content you expect.

Excel IF formula

Discussion in 'Computers/Gadgets' started by reddave, Jan 15, 2009.

  1. reddave

    reddave
    Expand Collapse
    Well-Known Member

    Joined:
    Apr 19, 2008
    Messages:
    715
    Likes Received:
    1
    need to do a IF formula where true value is 0 and the false value is a other formula. cant get the other formula to work it just puts the actual formula in the cell.

    wrecking my head .
     
    #1 reddave, Jan 15, 2009
  2. mrpickwick

    mrpickwick
    Expand Collapse
    Well-Known Member

    Joined:
    Apr 12, 2008
    Messages:
    53
    Likes Received:
    0
    send us the xls & will sort for ya
     
    #2 mrpickwick, Jan 15, 2009
  3. RedWally

    RedWally
    Expand Collapse
    Well-Known Member

    Joined:
    Aug 15, 2007
    Messages:
    1,364
    Likes Received:
    0
    Are you leaving out the equals sign.

    Format is as follows:

    =IF ( logical_test, value_if_true, value_if_false )

    Example

    =IF(D1<26,100,200)

    The above will enter 100 in the cell if cell D1 is less than 26, otherwise it shows 200
     
    #3 RedWally, Feb 5, 2009
  4. 25052005

    25052005
    Expand Collapse
    Well-Known Member

    Joined:
    Nov 13, 2007
    Messages:
    146
    Likes Received:
    0
    Exactly. . . if you still cant get it lash up the formula you are using
     
    #4 25052005, Feb 5, 2009
(You must log in or sign up to post here.)

Share This Page