simora
10-17-2014, 01:34 PM
In Cell D2 I am using this formula =CONCATENATE(BookNumber1, " ","","-","",C2)
BookNumber1 is a single cell Named Range
How do I modify it so that If C2 >0 & E2>0 then trigger the CONCATENATE function, else return nothing ("") I HAVE TO FILL THIS FORMULA DOWN THE PAGE TO ROW 366
cANT UNDERSTAND WHY THIS IS NOT WORKING. hOW DO i CORRECT THIS.?
=IF(AND(C2>0,E2>0,CONCATENATE(BookNumber1, " ","","-","",C2)),” ”)
BookNumber1 is a single cell Named Range
How do I modify it so that If C2 >0 & E2>0 then trigger the CONCATENATE function, else return nothing ("") I HAVE TO FILL THIS FORMULA DOWN THE PAGE TO ROW 366
cANT UNDERSTAND WHY THIS IS NOT WORKING. hOW DO i CORRECT THIS.?
=IF(AND(C2>0,E2>0,CONCATENATE(BookNumber1, " ","","-","",C2)),” ”)