try something like this to find the last entered NUMBER in row 3
=LOOKUP(9.99999999999999E+307,3:3)
--
Don Guillett
SalesAid Software

"Excel Dummy" wrote in message
...
Ok, I have a spreadsheet with this code in H10

=IF(H6="---",-20,IF(G6H6,(G6-H6)*5,IF(G6<H6,(H6-G6)*10/-1,0)))

In cell
D6=150
E6="---"
F6="---"
G6="---"
H6=145

What I want is for the formula to skip over the cells that have the "---"
in
them and then do the equation with the last number entered, in this case
in
cell D6 and H6.

Is this possible? Any help would be appreciated. Thanks!

Michelle