Using IF, OR function together

[niebo]

I have created a spreadsheet for monitoring software trials that I'm initiating. One of the auto calculated columns I have is the status of a trial (active or inactive). I want to take that formula and drag it down to the other empty cells in the column (the rows themselves are yet blank because I add trials as they occur to the spreadsheet).

Currently if I use a formula in column Q which looks like this:
=IF(J2<=0,"INACTIVE,"ACTIVE")

Column J is my Trial End Date column with a date value

What I would like to happen is that if the J2 cell is empty, I want a return of nothing in the cell.

Otherwise if I just drag the formula down in column Q, and there is no value in column J, I get a "INACTIVE" result in the cell. I just want that cell empty.

Can someone please help?

Thank you

[Jonmo1]

Try

=IF(J2="","",IF(J2<=0,"INACTIVE,"ACTIVE"))

[pjwhitfield]

=IF(ISBLANK(J1),"",IF(J1<=0,"Inactive","active"))

[niebo]

Thank you both for the lightning quick response!

[niebo]

Sorry guys, just tested and neither work...I think it has some thing to do with the <=0 since it's a date?

So if the cell is less than or equal to today's date, it's either active or inactive

[niebo]

I tried using this:

=IF(ISBLANK(J1),"",IF(J1<=TODAY(),"Inactive","active"))

It seems to solve the problem