If then statement
Closed
Excelley
-
Jul 30, 2010 at 09:40 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- If then statement
- Fenix internet l on bank statement - Guide
- How many if statements can you nest in excel - Guide
- Sbi statement - Guide
- If statement with date range - Guide
- How to remove false from if statement ✓ - Forum - Excel
1 reply
rizvisa1
Jul 30, 2010 at 10:05 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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