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.

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.

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.

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.

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