| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I skip over null cells?
Ok, I have a spreadsheet with this code in H10
=IF(H6="---",-20,IF(G6H6,(G6-H6)*5,IF(G6<H6,(H6-G6)*10/-1,0))) In cell D6=150 E6="---" F6="---" G6="---" H6=145 What I want is for the formula to skip over the cells that have the "---" in them and then do the equation with the last number entered, in this case in cell D6 and H6. Is this possible? Any help would be appreciated. Thanks! Michelle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
| How to skip cells with text strings. | Excel Discussion (Misc queries) | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
Threaded Mode
