Excel question
 

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??

Excel question
 

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:A290),A1:A29)*50

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

--
Gary''s Student - gsnu200840


"sparrow" wrote:

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??