1. #1

    Question Question about a complex excel formula

    Hi there,
    i got a question about excel.

    i want to do the following within a cell, when having two tabs:

    in tab2 - A1:

    if tab1, B1 = X, then set this cell to tab1, A1. Else hide this column.



    A solution to this would be nice
    Programming today is a race between software engineers striving to build bigger and better idiot-proof programs,
    and the universe trying to produce bigger and better idiots. So far, the Universe is winning." -- Rich Cook

  2. #2
    Quote Originally Posted by Silvator View Post
    Hi there,
    i got a question about excel.

    i want to do the following within a cell, when having two tabs:

    in tab2 - A1:

    if tab1, B1 = X, then set this cell to tab1, A1. Else hide this column.



    A solution to this would be nice
    Code:
    =IF(Sheet1!A1=X,X,"")
    that or just if it has anything in it? - if you want an "if it has anything in it" then the following should work:

    Code:
    =IF(Sheet1!A1,Sheet1!A1,"")
    Edit - Obviously you need to replace Sheet1 with whatever you called your sheet. the ! after Sheet1 specifies that it's a different tab / sheet.

    A1 is just the reference cell (of course).

    This is one of the simpler features of excel, which you could have made from using the formula function.

    Fx (Insert Function) -> IF ->
    Logical Test: (Select Cell(s))
    [possibly insert = or != for equals / not equal to]
    Value if true: (any number that you want, or to show the same as another cell, go select that cell)
    Value if false: leave blank or enter "" which is the same as rendering nothing in the box.
    Last edited by Yohassakura; 2013-01-22 at 07:02 PM.
    Kuroiwolf - 90 Brewmaster Monk
    Youtube Account Twitch TV
    Computer: Intel I7-3770k @ 4.5GHz | 16GB 1600MHz DDR3 RAM | AMD 7970 GHz @ 1200/1600 | ASUS Z77-V PRO Mobo|

Posting Permissions

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