Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am new to VBA. However I have created a custom function using VBA and the
code is detailed below. Public Function PLF(UnitsGenerated, PlantCapacity) ' This user defined function provides the PLF of the Plant in two decimals PLF = (UnitsGenerated / PlantCapacity) * 8.76 PLF = Application.Round(PLF, 2) End Function The result of this custom function is shown in two digits. But I want a percent symbol along with this result. Can anyone would suggest me the code to be added for this for which I thank you in advance. seenu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |