Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Preserve format, right tab using concatenate | Excel Worksheet Functions | |||
Concatenate format | Excel Worksheet Functions | |||
How do I format Concatenate function? | Excel Discussion (Misc queries) | |||
Vlookup, Concatenate, Format | Excel Discussion (Misc queries) | |||
concatenate and format | Excel Worksheet Functions |