| 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 ___ |
| 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) | |||
Threaded Mode
