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!
|