Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 9th 09, 08:30 PM posted to microsoft.public.excel.misc
eed eed is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 20
Default 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.

Please help - thanks!




  #2   Report Post  
Old September 10th 09, 07:07 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 1
Default 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.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017