Help with changing a formula
 

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!

Help with changing a formula
 

=IF(INDEX(F:L,ROW()=0),IF(COUNTBLANK(INDEX(F:L,RO W(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))
"JBoyer" wrote in message
...
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!

Help with changing a formula
 

That formula didnt seem to work for me...

"Corey" wrote:

=IF(INDEX(F:L,ROW()=0),IF(COUNTBLANK(INDEX(F:L,RO W(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS",""))
"JBoyer" wrote in message
...
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!

Help with changing a formula
 

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" wrote in message
...
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!

Help with changing a formula
 

Yes, Perfect! Thanks

"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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!