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
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.
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.
Related:
- If then statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement with text - Guide
- How many if statements can you nest - Guide
- Vba case statement with string - Guide
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
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
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
