Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default IF, Then

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),")"), " ")))))))
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"