Excel question

S

sparrow

For a formula that uses numbers from a previous row. If the previous row
isnt filled out, how do I get my formula to calculate on the last row that
was filled out??
 
G

Gary''s Student

Say in A30 we have a formula like =A29*50
But if A29 is empty, we want the formula to find the last value that was
filled in and multiply it by 50.

In A30, enter:

=LOOKUP(2,1/(A1:A29>0),A1:A29)*50

So if A29 is still empty, but A28 contains 10, then formula will display 500
 
Top