Hello Everybody
I am trying to use the IF command in order to show a certain cell if it has got a certain value. I want these values to be shown in a an other sheet in the workbook but i always get some blank lines.
The command i am using is:
=IF('sheet1'!H4="non conformance";'General'!D4;"")
I know that the "" i am using gives the blanc space. But is there a way that i can avoid that and the answers are placed without the gaps?
Kind Regards
Bookmarks