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'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)
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" <[email protected]> wrote in message
news:[email protected]...
> 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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks