Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was recently challenged to create a formula that displays two values
separated by a slash in the same cell. For example A1=40 and B2= 10. C3 displays [30 / .75]. The difference between the two, and what should be the percentage. The formula I put together is =(A1-B2)&" / "&((A1-B2)/A1). The formula works but I can not get the second value to format as a %, it only displays as a decimal. Does anyone know how I can make the second value display as a percentage without messing up the formatting of the first value? Any advice would be much appreciated. Thanks, Carter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom field with custom formula in pivot table! | Excel Worksheet Functions | |||
Conditional formatting with multiple formula | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Custom Formatting For Multiple Currency Symbols | Excel Discussion (Misc queries) | |||
custom formatting?? | Excel Worksheet Functions |