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) |
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) |
All times are GMT +1. The time now is 08:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com