I am not a guru on Excel and I am reaching out to get help with the following please:
Time used (%)
I need to use Excel IF function to show the word 'Keep' if the application is used more than 10% of the time, or the word 'Cancel' if it is used 10% or less of the time. Also to insert a column on the right called Keep or Cancel, and use the relevant Excel function to show Keep or Cancel for each row.
and copy the formula down the column. But, I'm assuming your % used data is actually numbers. Since they are left justified, it appears they could actually be text. If that's the case then excel will treat all of them as > 10. If that's the case, then change the cell format to text, then re-confirm the data using text to columns (copying instructions from one of @Hans Vogelaar's posts):
On the Data tab of the ribbon, click Text to Columns. Select Delimited, then click Next >. Click Next > again. In Step 3, select General Click Finish.