Did you take a look at the revised code that I provided?

http://google.com/groups?threadm=jem...81821122003%40
msnews.microsoft.com

I *think* it does what you expect.

Note that, based on your earlier problem statement, and entry in
AD19 will reference P11, not P10. Likewise, AM19 will reference P12
and AV19 will reference P13.

In article ,
"Phil Hageman" wrote:

Paul, thanks very much for your help - appreciate your
time. Before I go further, please know I am not a
programmer and a lot of this code I do not understand.
That said, the following:

i.) The space was added, which cleared a compile error.
ii.) .5, or 50%, is the correct answer - but I'm still
getting a blank in X19, and, #Div/0! when I make entries
in AD19 (error in AG19), AM19 (error in AP19), and AV19
(error in AY19). Seems like it is looking in the wrong
place for the divisor (thus a blank and #Div/0!)?. The
inputs were made in the correct order.
iii.) Could this be a clue - for AD19, AM19 and AV19, it
should not be looking in P42 or V42, rather, P10 and V10.