|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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!
|