LinkBack URL
About LinkBacks
Hi all
I want to reference a cell (title) to another cell h8 which contains 60%
I use the formulae "widgets below"& h8 - however it comes out as "widgets below 0.6". How do I change the 0.6 to 60%?
Hi all
I want to reference a cell (title) to another cell h8 which contains 60%
I use the formulae "widgets below"& h8 - however it comes out as "widgets below 0.6". How do I change the 0.6 to 60%?
Try this:
="widgets below"&H8*100&"%"
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
="widgets below "&TEXT(J1,"00%")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
perfect - thank you for that! I used Oeldere suggestion in the end.
Thanks for the rep.
Glad I could help.
Thanks for marking the question solved.
No rep for me - obviously not good enough.
@AliGW
Of course good enough. Rep. will come soon I suppose. The hint is clear enough.
LOL! It's up to the OP, of course. Just being a bit flippant, since I am often accused of being too serious.
Lol sorry.😬. Will add a rep when I get on my laptop. Can't seem to add rep on phone.👍
That’s kind, but honestly not necessary. I was having a bit of fun.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks