Notifications
Clear all
Topic starter
Hello,
Is there away to make the combined value of a text and a percentage as a percentage? In column D attached I'd like to keep the percentage that is in column C and not .15. I like it to say the product and then 15%. How should I format the concatenated cells in column D.
Thanks!
Posted : 01/08/2020 3:49 pm
Link to the spready is not working (might be the file name), but is this what you are after?
=B1&" "&TEXT(A1,"#%")
Posted : 01/08/2020 3:54 pm
Topic starter
Yes this worked! Thank you! Is there away to set it up so if there is no promotion for the week then the cell stays blank instead of it showing a %? I've reattached the spreadsheet with a different name. Hopefully it can be opened.
Posted : 04/08/2020 1:07 pm
Yes mate, just do an if
=IF(B2="","",B2&" "&TEXT(C2,"#%"))
Posted : 04/08/2020 2:05 pm
