Home 
Search 
Today's Posts 
#1




Formatting Percentages/LOOKUP using a Percentage
I have a column in a spreadsheet in which I need to return a letter
sequence/"score". The sequence is based on two criteria: 1. LOOKUP  for which the reference data is a list of percentages in the following format: 1.00%. 2. A column containing a formula which calculates a percentage. The letter sequence/score will not generate, and shows as #N/A. I have tried copy/paste special values to remove the formula, but the sequence will still not generate because the percentages are in the following format: 1.000000000000000%. I have to manually rekey the percentage for every cell in order to get the score to generate in the 'score' column. Please help  thanks! 
#2




Formatting Percentages/LOOKUP using a Percentage
I'm not sure how you have your formula structured or how the percentage column is formated, either could potentially be causing your problem. But if say your percentage column was "F" this formula should work *=LOOKUP(F2,{0,0.6,0.63,0.67,0.7,0.73,0.77,0.8,0.8 3,0.87,0.9,0.93,0.97},{"F","D","D","D+","C","C","C+","B","B","B+","A","A","A+"})*. You need to remember to put the decimals in your "lookup_vector" arguments and remember the "{}" in your formula. If this doesn't help or shed light on the problem please reply with a sample of the LOOKUP formula as well as a sample of the formula that is calculating the percentage. Best of Luck, Dan eed;482537 Wrote: I have a column in a spreadsheet in which I need to return a letter sequence/"score". The sequence is based on two criteria: 1. LOOKUP  for which the reference data is a list of percentages in the following format: 1.00%. 2. A column containing a formula which calculates a percentage. The letter sequence/score will not generate, and shows as #N/A. I have tried copy/paste special values to remove the formula, but the sequence will still not generate because the percentages are in the following format: 1.000000000000000%. I have to manually rekey the percentage for every cell in order to get the score to generate in the 'score' column. Please help  thanks!  Dan DeHaven  Dan DeHaven's Profile: http://www.thecodecage.com/forumz/member.php?userid=748 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=133092 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Formatting Percentages  Excel Discussion (Misc queries)  
trouble formatting percentages  Excel Discussion (Misc queries)  
Lookup percentages  Excel Discussion (Misc queries)  
Percentage Increase Between 2 Percentages  Excel Discussion (Misc queries)  
Lookup percentages, return names  Excel Discussion (Misc queries) 