Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am getting an error when I do this. Do you know what the problem is? Or
if there is a simpler way to do this? =IF(Sheet1!B610,CONCATENATE(Sheet1!A61," (",FIXED(Sheet1!B61,2)," - ",FIXED(Sheet1!D61,2),")"),IF(Sheet1!B620,CONCATE NATE(Sheet1!A62," (",FIXED(Sheet1!B62,2)," - ",FIXED(Sheet1!D62,2),")"),IF(Sheet1!B630,CONCATE NATE(Sheet1!A63," (",FIXED(Sheet1!B63,2)," - ",FIXED(Sheet1!D63,2),")"),IF(Sheet1!B640,CONCATE NATE(Sheet1!A64," (",FIXED(Sheet1!B64,2)," - ",FIXED(Sheet1!D64,2),")"),IF(Sheet1!B650,CONCATE NATE(Sheet1!A65," (",FIXED(Sheet1!B65,2)," - ",FIXED(Sheet1!D65,2),")"),IF(Sheet1!B660,CONCATE NATE(Sheet1!A66," (",FIXED(Sheet1!B66,2)," - ",FIXED(Sheet1!D66,2),")"), IF(Sheet1!B670,CONCATENATE(Sheet1!A67," (",FIXED(Sheet1!B67,2)," - ",FIXED(Sheet1!D67,2),")"), " "))))))) |