Formula - Use last value above 0

[dlvgolf]

Using =IF(B14<1,,A14+B14-B13) in Cell C14.
All cells don't contain data.
If B8 thru B13 are blank but B7 has data... how do I make the formul
go find the last data above in column B? (See attached file)

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45820

 

[Cesar Zapata]

PLEASE DO NOT ATTACH FILES!!!!

 

[Frank Kabel]

Hi
if I understood you want to create a formula which does the following:
=IF(B14<1,,A14+B14-last_entry in col B)

Try the following
=IF(B14<1,,A14+B14-VLOOKUP(7E30,$B$3:$B13,1))

 

[dlvgolf]

Perfect! Thanks very muc