Previous Topic Next Topic

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

Answer 1 / 1
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
Ask a question