subtracting with blank rows inbetween?

S

STLMO

In Excel 2003 I have created a database to show progressive weight loss (or
gain). I would like the result displayed in column F only after a number is
entered in column E. The following works until I have a blank row. Would I
have to adjust the formula each time a blank row is encountered?

=IF(E2=0,"",E1-E2)

E F
1 150 ___ (starting weight)
2 149 ___ (formula beginning here)
3 blank row
4 blank row
5 148 ___
 
T

T. Valko

Enter this formula in F2 and copy down as needed:

=IF(E2="","",LOOKUP(10000,E$1:E1)-E2)
 
S

STLMO

Yes, yes, it worked perfectly! Thank you so very much. I will read & study
more to understand what LOOKUP(10000 means

Again, thank you for your time and expertise.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Formula than understands midnight? 26
sumif returns blank if all cells blank 7
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
vlookup or some other function that counts rows 0
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Copying formulas across columns 2
Vlookup? 1

Top