Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to copy a formula n Excel but skip any blank cells
I'm trying to copy(downward) a formula but I want it to leave blank cells
blank. It's gining it a value of 0 currently. Here's the formula I want copied skipping blank cells. =IF(+E8=0,0,+F8/E8) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to copy a formula n Excel but skip any blank cells
Try =IF(ISBLANK(E8),"",IF(E8=0,0,F9/E8))
or =IF(E8="","",IF(E8=0,0,E9/F8)) This is called 'nesting' of IFs best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ann" wrote in message ... I'm trying to copy(downward) a formula but I want it to leave blank cells blank. It's gining it a value of 0 currently. Here's the formula I want copied skipping blank cells. =IF(+E8=0,0,+F8/E8) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip blank cells in diagrams | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
how do I get excel to ignore blank cells in formulas | Excel Worksheet Functions | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) |