Remember Me?

#1
September 9th 09, 08:30 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2009 Posts: 20
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 re-key the percentage for every cell in order to get the
score to generate in the 'score' column.

#2
September 10th 09, 07:07 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2009 Posts: 1
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 re-key the percentage for every cell in order to get
the
score to generate in the 'score' column.

--
Dan DeHaven
------------------------------------------------------------------------
Dan DeHaven's Profile: http://www.thecodecage.com/forumz/member.php?userid=748

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JB Excel Discussion (Misc queries) 1 July 3rd 08 01:30 AM [email protected] Excel Discussion (Misc queries) 2 March 18th 08 08:50 PM tmarsh7407 Excel Discussion (Misc queries) 12 September 27th 07 09:15 PM [email protected] Excel Discussion (Misc queries) 4 February 26th 07 09:45 PM 360Kid Excel Discussion (Misc queries) 2 October 11th 06 11:09 PM

All times are GMT +1. The time now is 09:37 PM.