View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Format CONCATENATE

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