Assigning values to a cell based on content
Posted on 2012-08-22
I'm not very knowledgeable in Excel, and I'm looking for a way to take the values in a single column, and based on their contents, assign one of 4 values in another column.
1. Column P shows a heading of "Mail Size". The data contains letters and numbers.
2. The value of Mailbox Size in column P will show letters and numbers like 275.5M, 1.1G, 5.9G, 958.5M, etc.
3. I'll need to recalculate the values in column P with the following formula: value+40%+15%= final result, returned in Gigabytes (G) and placed into column Q.
4. I'd like to assign the result of the formula for column Q one of 4 values based on the result of the formula into column R.
So, column P value is calculated with the formula (v+40%+15%=F) and stored in column Q. Column Q's values are checked against a lookup and based on the values, assigned 1 of 4 results in column R:
< 1GB = 1
>1GB but <3GB= 3
>3GB but <7GB = 7
Am I making sense on this at all? I'm really hoping someone can help me with this. Thank you in advance for your help.