Forum Discussion
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 ...
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.