Forum Discussion

VMiles322's avatar
VMiles322
Copper Contributor
Apr 16, 2021

Excel task I need assistance with

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

Formulas and Functions

1 Reply

Sort By
  • JMB17's avatar
    JMB17
    Bronze Contributor
    Apr 16, 2021

    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 HansVogelaar'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.

Resources