Help with changing a formula

  • Thread starter Thread starter JBoyer
  • Start date Start date
J

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!
 
=IF(INDEX(F:L,ROW()>=0),IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))
 
That formula didnt seem to work for me...

Corey said:
=IF(INDEX(F:L,ROW()>=0),IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))
Click to expand...
 
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
 
Yes, Perfect! Thanks

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top