i am trying to format the result of a concatenate equation so that it may
have 2 decimal places. There is no trouble with the function itself just
formatting.

the equation is:

=CONCATENATE(IF(AND(AW$7=$E12,AW$7<=$H12),(($D12* $I12)/$J12/40),""),IF....(goes on for 12 more times with different criteria and references)

Where
AW7,E12,and H12 are dates (dd/mm/yy)
D12 and J12 are numbers (no formating)
I12 is a percent (no decmials)

thanks

try substituting

TEXT(($D12*$I12)/$J12/40,"##.00")

for

($D12*$I12)/$J12/40

within the body of your formula

"Dave" wrote:

i am trying to format the result of a concatenate equation so that it may
have 2 decimal places. There is no trouble with the function itself just
formatting.

the equation is:

=CONCATENATE(IF(AND(AW$7=$E12,AW$7<=$H12),(($D12* $I12)/$J12/40),""),IF....(goes on for 12 more times with different criteria and references)

Where
AW7,E12,and H12 are dates (dd/mm/yy)
D12 and J12 are numbers (no formating)
I12 is a percent (no decmials)

thanks

if you want two decimal places you might try
....text(40*($D12*$I12)/$J12,".00")...to replace ), (($D12*$I12)/$J12/40)

"Dave" wrote:

i am trying to format the result of a concatenate equation so that it may
have 2 decimal places. There is no trouble with the function itself just
formatting.

the equation is:

=CONCATENATE(IF(AND(AW$7=$E12,AW$7<=$H12),(($D12* $I12)/$J12/40),""),IF....(goes on for 12 more times with different criteria and references)

Where
AW7,E12,and H12 are dates (dd/mm/yy)
D12 and J12 are numbers (no formating)
I12 is a percent (no decmials)

thanks

No need to start a new thread... See one answer at your previous thread.


In article ,
Dave wrote:

i am trying to format the result of a concatenate equation so that it may
have 2 decimal places. There is no trouble with the function itself just
formatting.

the equation is:

=CONCATENATE(IF(AND(AW$7=$E12,AW$7<=$H12),(($D12* $I12)/$J12/40),""),IF....(go
es on for 12 more times with different criteria and references)

Where
AW7,E12,and H12 are dates (dd/mm/yy)
D12 and J12 are numbers (no formating)
I12 is a percent (no decmials)

thanks