Format CONCATENATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
if you want two decimal places you might try
....text(40*($D12*$I12)/$J12,".00")...to replace ), (($D12*$I12)/$J12/40)
 
Back
Top