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
Bookmarks