VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
Dear All Board Members,
I need here help to understand in this formula...
What is the meaning of this-
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"