If then statement

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I am trying to print the contents of range a1:h1 if I1<>"".

So far I've got,

IF(I1<>"",A1:H1)

but I only get the results of A1, not B1:H1.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You cannot have it like that.
IF(I1<>"",A1:H1)
you can have done some to range(a1:h1) but if you just want to show the values of a1, h1. This is not possible to do so in one cell like that