If then statement

Closed
Excelley - Jul 30, 2010 at 09:40 AM
rizvisa1 Posts 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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