Help with changing a formula

[JBoyer]

The current formula I have is...
=IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS","")

I want to make one addition to this formula. Before it does my current
formula I want it to check if any cells in F:L,ROW() are <0, if they are i
want it to be blank, if not then I want it to perform my current formula.

THANKS IN ADVANCE!

 

[Corey]

=IF(INDEX(F:L,ROW()>=0),IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))

 

[JBoyer]

That formula didnt seem to work for me...

=IF(INDEX(F:L,ROW()>=0),IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))

 

[Rick Rothstein \(MVP - VB\)]

Does this do what you want?

=IF(COUNTIF(F:L,"<0")>0,"",IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))

Rick

 

[JBoyer]

Yes, Perfect! Thanks

Does this do what you want?

=IF(COUNTIF(F:L,"<0")>0,"",IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))

Rick