subtracting with blank rows inbetween?
 

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 ___

subtracting with blank rows inbetween?
 

Enter this formula in F2 and copy down as needed:

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

--
Biff
Microsoft Excel MVP


"STLMO" wrote in message
...
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 ___

subtracting with blank rows inbetween?
 

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.

"T. Valko" wrote:

Enter this formula in F2 and copy down as needed:

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

--
Biff
Microsoft Excel MVP


"STLMO" wrote in message
...
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 ___

subtracting with blank rows inbetween?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"STLMO" wrote in message
...
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.

"T. Valko" wrote:

Enter this formula in F2 and copy down as needed:

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

--
Biff
Microsoft Excel MVP


"STLMO" wrote in message
...
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 ___