How? Ignore cell if blank in an IF formula.

**n2lectual** · 03-26-2008, 03:25 PM

I have 2 cells I am monitoring.

Cell K18 has the highest number that was last entered (numbers are sequential).

I18 is blank until new number is entered.

I19 is the cell I have this formula in.
=IF(K18+1=I18,"","OUT OF SEQUENCE")

I want this cell to return a statement only if the number, when entered into cell I18 is NOT the next number in the sequence (OUT OF SEQUENCE), which would be K18+1.
I want no statement if blank or is the correct number, although I could put up with an "OK" if I can get it when the correct number is entered or when cell is blank.
Thanks

**darkyam** · 03-26-2008, 03:27 PM

=if(or(i18="",k18+1=i18),"","Out Of Sequence")

**NBVC** · 03-26-2008, 03:28 PM

Not sure I understand... it seems your current formula does what you require... am I missing something?

**darkyam** · 03-26-2008, 03:34 PM

I18, if blank, does not equal K18+1 if K18 is the max value in a range, so the formula now in I19 would return "Out of Sequence" until a correct number is entered.

**NBVC** · 03-26-2008, 03:36 PM

I guess I may have assumed there was always an entry in I18...

**n2lectual** · 03-26-2008, 03:42 PM

Current formula returns statement if incorrect number is entered as needed, BUT also returns same statement if cell is blank as cell always is until an entry is made.

I am trying to have this as an alert if someone else enters a number that is out of sequence.

I need it not to say anything if cell remains blank or the corrrect number is entered. Can the blank cell be ignored?

**NBVC** · 03-26-2008, 03:45 PM

Originally Posted by n2lectual

Current formula returns statement if incorrect number is entered as needed, BUT also returns same statement if cell is blank as cell always is until an entry is made.

I am trying to have this as an alert if someone else enters a number that is out of sequence.

I need it not to say anything if cell remains blank or the corrrect number is entered. Can the blank cell be ignored?

Did you see darkyam's response... I think he took care of that.