| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ___ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ___ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ___ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ___ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| How can I add rows inbetween? | Excel Worksheet Functions | |||
| How do I enter a row inbetween two rows? | Excel Discussion (Misc queries) | |||
Linear Mode
