Some symbol in formula wanted to understand..

[VBABEGINER]

Dear All Board Members,

I need here help to understand in this formula...

=IFERROR(IF($D12<>"",IF($A12="Yes",TEXT(IFERROR(VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,8,0)/VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,9,0),"-"),"0.0")*100,IFERROR(IF(AND($A12="No",COUNTIF($BJ$1:$BJ$84,$E12)>0),TEXT(IFERROR(VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,8,0)/VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,9,0),""),"0.00"),IFERROR(IF(AND($A12="No",COUNTIF($BK$1:$BK$84,$E12)>0),TEXT(IFERROR(VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,8,0)/VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,9,0),"-"),"$#,##0.00"),VLOOKUP(CONCATENATE($C12,$D12,$E12,$F12,$G12,$H12),Weekly_Pivot!$L:$T,8,0)),"-")),"-")),""),"-")

What is the meaning of this-

"$#,##0.00"

 

[Rick Rothstein]

What is the meaning of this-

"$#,##0.00"

It is the format pattern for the TEXT function (I know it is kind of hard to see the linkage what with all those function calls in between).

 

[Marcelo Branco]

Take a look at
https://support.office.com/en-us/ar...r-format-78f2a361-936b-4c03-8772-09fab54be7f4
where you can find the meaning of each symbol.

M.