Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Coddie
 
Posts: n/a
Default How do you copy a cell formula down a column without displaying n.

I want to insert a formula into my worksheet and copy it down the column
without displaying anything in each cell until a value is established.
Example would be
A3-A2+A1 would be the formula I want the answer to show up in cell A4. I
want to copy the formula from A5 down to A25, but I don't want the result of
cell A4 to show up in each cell.
  #2   Report Post  
Ola
 
Posts: n/a
Default

Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)),A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.

Ola Sandstrom

  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Ola" wrote...
Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)), A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.


Alternatively, 'OR' semantics:
=IF(COUNT(A1:A3)=1,A3-A2+A1,"")

'AND' semantice:
=IF(COUNT(A1:A3)=3,A3-A2+A1,"")


  #4   Report Post  
Coddie
 
Posts: n/a
Default

Yes! It was exactly what I needed. Thank you for your time and assistance.

Coddie

"Harlan Grove" wrote:

"Ola" wrote...
Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)), A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.


Alternatively, 'OR' semantics:
=IF(COUNT(A1:A3)=1,A3-A2+A1,"")

'AND' semantice:
=IF(COUNT(A1:A3)=3,A3-A2+A1,"")



  #5   Report Post  
Coddie
 
Posts: n/a
Default

Thank you so much! It worked! I really appreciate your assistance!

coddie

"Ola" wrote:

Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)),A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.

Ola Sandstrom

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
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 13th 05 12:55 AM
to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . bvi Excel Worksheet Functions 3 December 23rd 04 07:14 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
Copy formula to every 12th cell Jerry Derfler Excel Worksheet Functions 3 November 15th 04 12:09 AM
How to populate column with formula based on value in cell Cameron Stewart Excel Worksheet Functions 2 November 2nd 04 02:36 AM


All times are GMT +1. The time now is 03:32 PM.

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

About Us

"It's about Microsoft Excel"