Excel task I need assistance with

[VMiles322]

Hi Excel community!

I am not a guru on Excel and I am reaching out to get help with the following please:

Software Licences
Application	Time used (%)	Keep
Accounts	18
Spreadsheet	13
Games	2
Publishing	5
Word processing	31
Presentations	14
File management	12
Database	3
Photo editing	2

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.

Your help is most appreciated.

Thanks,

Victoria

[#2]

Assuming time used data starts in cell B3, try:

=IF(B3>10,"Keep","Cancel")

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.