View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBoyer JBoyer is offline
external usenet poster
 
Posts: 72
Default 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!