Try this:

=If(ISNA(Match($A$2,'L:\SPA_HRP\Dashboards\Reports \Branches\Working
Dashboards\[Terms.xls]Terms'!$A$6:$A$30,0)),0,CONCATENATE("*Of these,
",ROUND(VLOOKUP($A$2,'L:\SPA_HRP\Dashboards\Report s\Branches\Working
Dashboards\[Terms.xls]Terms'!$A$6:$D$30,3,FALSE),0 ),"
(",ROUND((VLOOKUP($A$2,'L:\SPA_HRP\Dashboards\Repo rts\Branches\Working
Dashboards\[Terms.xls]Terms'!$A$6:$D$30,3,FALSE)/C12)*100,1),"%)","
have been employed for more than 2 years, compared with
",ROUND(VLOOKUP("total",'L:\SPA_HRP\Dashboards\Rep orts\Branches\Working
Dashboards\[Terms.xls]Terms'!$A$6:$D$30,3,FALSE),0),"
(",ROUND((VLOOKUP("total",'L:\SPA_HRP\Dashboards\R eports\Branches\Working
Dashboards\[Terms.xls]Terms'!$A$6:$D$30,3,FALSE)/E12)*100,1),"%)"," in
the Branch."))

I copied this from your post, so watch out for word-wrap!
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Outapin" wrote in
message ...

Thanks , but where do I put this in my formula ? Before the ROUND ?
This is where I get all mixed up with Excel formulas.... it's where to
put it...!!
Thanks


--
Outapin
------------------------------------------------------------------------
Outapin's Profile:
http://www.excelforum.com/member.php...o&userid=29278
View this thread: http://www.excelforum.com/showthread...hreadid=500238