Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 07:49 PM posted to microsoft.public.excel.worksheet.functions
Ann
 
Posts: n/a
Default 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   Report Post  
Old December 12th 05, 07:55 PM posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Skip blank cells in diagrams hlp Charts and Charting in Excel 9 February 24th 06 03:32 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
Excel VB-Copy formula down until adjacent cell (left) is blank? Tony P. Excel Discussion (Misc queries) 1 May 18th 05 06:11 PM
how do I get excel to ignore blank cells in formulas rbignami Excel Worksheet Functions 1 May 6th 05 03:18 AM
Copy down - special to fill only the blank cells Mike Excel Discussion (Misc queries) 3 April 18th 05 10:08 PM


All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017