Snake Plissken wrote:
U¿ytkownik "bhalooneel"
napisa³ w
wiadomo¶ci ....

I have the following formula in a cell:
=IF(MID(S1,16,1)="6","OK","RECHECK")

But I would like to include the possibility that the cell may be empty,
in which case, this would also be OK. But I'm having trouble
incorporating an OR statement to say OR = blank, or something along
those lines.



=IF(S1<"";(IF(MID(S1,16,1)="6","OK","RECHECK");"O K")

Or...

=IF(OR(MID(S1,16,1)="6",S1=""),"OK","RECHECK")