I have a couple of questions regarding the formula below.
1- Is there anyway I can format the numbers? ex. ##,### (i need to add
the commas).
2- Is there anyway to streamline the formula?
Any help is appreciated!........
This is the results:
Outcollect Revenue increased $564K from November 04 ($3077K) to December 04 ($3641K). The MOUs increased 9180K from November 04 (35360K) to December 04 (44540K) resulting in an increase of $799K. The rate decreased $0.01 resulting in a decrease of $235K.
This is the formula used to get these results:
="Outcollect Revenue"&" "&W151&" "&"$"&ROUND(ABS(H151),-3)/1000&"K"&" "&"from"&" "&$E$7&" "&"("&"$"&ROUND(ABS(E151),-3)/1000&"K)"&" "&"to"&" "&$F$7&" "&"($"&ROUND(ABS(F151),-3)/1000&"K)."&" "&"The MOUs"&" "&X151&" "&ROUND(ABS(M151),-3)/1000&"K"&" "&"from"&" "&$E$7&" "&"("&ROUND(ABS(K151),-3)/1000&"K)"&" "&"to"&" "&$F$7&" "&"("&ROUND(ABS(L151),-3)/1000&"K)"&" "&"resulting in"&" "&IF(X151="increased","an increase","a decrease")&" "&"of"&" "&"$"&ROUND(ABS(U151),-3)/1000&"K"&"."&" "&"The rate"&" "&Y151&" "&"$"&ROUND(ABS(R151),2)&" "&"resulting in"&" "&IF(Y151="increased","an increase","a decrease")&" "&"of"&" "&"$"&ROUND(ABS(T151),-3)/1000&"K."
1- Is there anyway I can format the numbers? ex. ##,### (i need to add
the commas).
2- Is there anyway to streamline the formula?
Any help is appreciated!........
This is the results:
Outcollect Revenue increased $564K from November 04 ($3077K) to December 04 ($3641K). The MOUs increased 9180K from November 04 (35360K) to December 04 (44540K) resulting in an increase of $799K. The rate decreased $0.01 resulting in a decrease of $235K.
This is the formula used to get these results:
="Outcollect Revenue"&" "&W151&" "&"$"&ROUND(ABS(H151),-3)/1000&"K"&" "&"from"&" "&$E$7&" "&"("&"$"&ROUND(ABS(E151),-3)/1000&"K)"&" "&"to"&" "&$F$7&" "&"($"&ROUND(ABS(F151),-3)/1000&"K)."&" "&"The MOUs"&" "&X151&" "&ROUND(ABS(M151),-3)/1000&"K"&" "&"from"&" "&$E$7&" "&"("&ROUND(ABS(K151),-3)/1000&"K)"&" "&"to"&" "&$F$7&" "&"("&ROUND(ABS(L151),-3)/1000&"K)"&" "&"resulting in"&" "&IF(X151="increased","an increase","a decrease")&" "&"of"&" "&"$"&ROUND(ABS(U151),-3)/1000&"K"&"."&" "&"The rate"&" "&Y151&" "&"$"&ROUND(ABS(R151),2)&" "&"resulting in"&" "&IF(Y151="increased","an increase","a decrease")&" "&"of"&" "&"$"&ROUND(ABS(T151),-3)/1000&"K."