Good Morning Team
For the life of me I have no idea how to do this or even if it is possible.
I have this formula
IF(LEN(F4/4)-FIND(".",F4/4)=1,F4/4&"0",F4/4)
which I use to add a 0 to a value that would normally end in for example ".2".
I would like to create a User Defined Function that I could just pass the values, or cells and values to it, and it would produce the required result.
The reason I want this is due to I am using the Concatenation feature to build up a statement.
something like this.
="Some text "&C5&" some more text "&D12/2&" Total = £ "&F23
Now you will know that if the values in the cells within the above formula end up as for example £5.20, they will be displayed as £5.2
To make it look and read better, I want to add the "0", but only need to add the zero if needed. So values like £5.22 would not need the zero added,
Hope all that makes sense, and any help would be appreciated.
Many thanks
BanburyS
Bookmarks