Changes

m
Experimenting with Power Query for Excel Formulas
Line 247: Line 247:  
|51  Labourers in processing, manufacturing and utilities
 
|51  Labourers in processing, manufacturing and utilities
 
|$19.61
 
|$19.61
 +
|}
 +
{| class="wikitable"
 +
|+
 +
!=$U$21&AM5#&"represent "&IF(--(AN5#+AP5#=0)+--(AO5#+AQ5#=0)>0,"an annualized total ","an annualized net ")&IF((AN5#+AO5#+AP5#+AQ5#)>0,"cost",IF((AN5#+AO5#+AP5#+AQ5#)<0,"cost savings",""))
 +
 +
&" of "&DOLLAR(ABS($AN5#+AO5#+AP5#+AQ5#),0)&". "
 +
!
 +
!
 +
!
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 
|}
 
|}