Excel task I need assistance with

Visitor

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

1 Reply

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.