Question about a complex excel formula

[Deleted]

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

[Yohassakura]

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

=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:

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