Apr 15 2021 07:08 PM
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
Apr 15 2021 09:42 PM - edited Apr 15 2021 09:43 PM
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.