worksheets acting perculiar...
for some reason whenever i run a formula down over selected cells the
information from the first cell is copied down until I save then the cells update to the proper information. -- A. |
worksheets acting perculiar...
ToolsOptionsCalculation tab, check Automatic
-- Kind regards, Niek Otten Microsoft MVP - Excel "Andmor" wrote in message ... | for some reason whenever i run a formula down over selected cells the | information from the first cell is copied down until I save then the cells | update to the proper information. | -- | A. |
worksheets acting perculiar...
ToolsOptionsCalculation.
Please set to "automatic". Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 07:42:00 -0800, Andmor wrote: for some reason whenever i run a formula down over selected cells the information from the first cell is copied down until I save then the cells update to the proper information. |
worksheets acting perculiar...
Gord, I posted this reply in my other post which is now 3 pages away...
wasn't sure if you'd see it so here it is again. I am using your lookup formula as my base but I don't understand why i'm getting an error. Here is my formula. =LOOKUP(L15,{0,49,50,53,54,56,57,59,60,63,64,66,67 ,69,70,73,74,76,77,79},{"F","D-",D,D+,"C-","C","C+",B-,"B","B+",A-,A,"A+"}) -- A. "Gord Dibben" wrote: ToolsOptionsCalculation. Please set to "automatic". Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 07:42:00 -0800, Andmor wrote: for some reason whenever i run a formula down over selected cells the information from the first cell is copied down until I save then the cells update to the proper information. |
worksheets acting perculiar...
You have more lookup values than return values.
LOOKUP uses the next highest value if it cannot find a match, so you don't need as many values as you have. Decide where the cutoff for any range will be then enter those in your formula. =LOOKUP(L12,{0,49,50,53,56,59,63,66,67,69,73,76,79 },{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"}) To test your values and lookups, enter the scores 48 to 79 in L15 down. Enter your formula in M15 and drag/copy down. See if the letter grades returned are what you want for each range of score. Gord On Wed, 6 Dec 2006 09:23:09 -0800, Andmor wrote: Gord, I posted this reply in my other post which is now 3 pages away... wasn't sure if you'd see it so here it is again. I am using your lookup formula as my base but I don't understand why i'm getting an error. Here is my formula. =LOOKUP(L15,{0,49,50,53,54,56,57,59,60,63,64,66,6 7,69,70,73,74,76,77,79},{"F","D-",D,D+,"C-","C","C+",B-,"B","B+",A-,A,"A+"}) Gord Dibben MS Excel MVP |
All times are GMT +1. The time now is 03:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com