If then statement

Closed
Excelley - Jul 30, 2010 at 09:40 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 30, 2010 at 10:05 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 30, 2010 at 10:05 AM
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
0