Solved How to move on to next cell if previous is blank?

September 26, 2015 at 17:43:53
Specs: Windows 7
I'm trying to have an if function that will give me training is ok if it between 1 to 333 days, soon if it is 334 TO 364 days, and DUE if its 365+ days, however I have a few blank cells, how can i make this work? So H2 to (starting of data) is blank and I2 has a date (my dates are in H2 till T219)

message edited by Ed1029


See More: How to move on to next cell if previous is blank?

Report •

#1
September 26, 2015 at 23:58:17
✔ Best Answer
It is not clear to me how you are calculating your "days" so it's hard to offer a specific solution. The best I can offer without more detail is this:

You could use a Nested IF to test for a blank cell:

=IF(H2="","",your IF function here))

This will return a blank cell if H2 is blank.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question