I have a table with several columns and want to make it work this way
If E7 is empty, than H7is empty
If E7 has X, than H7 is empty
If E7 has any other value than X H7 has X
=IF(E7<>0,"X",IF(E7="","",IF(E7=X,"")))
My formula isn't working, because X falls under <>0, so when there is an X in E7 I get an X in H7, but I need it to be available to accept a different value.
Also, how can I apply this formula to several columns within the same table, meaning if there is a value in, let's say, E7 other cells (like J7, K7) will automaticaly receive an X?
In this case E7 is the first cell from the left, so all others in the row will be filled in as I go, but what if value has to be put in in cell K7? I can go directly to it, but wil it put an X into other cells.
Basicaly all these cells receive the same value but only one of them in given row can have it, the others I want to have an X, so I don't put anything in it by accident.
Thank You in advance for helping
Bookmarks