Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 1st 05, 10:31 PM
Shelly9633
 
Posts: n/a
Default How do I create a formula for an entire column

I want to create a formula that uses an IF function, and have it apply to an
entire column. I tried naming the column, and defining the formula, but
nothing happens.

  #2   Report Post  
Old August 1st 05, 10:48 PM
Bob Phillips
 
Posts: n/a
Default

What problem are you trying to solve?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shelly9633" wrote in message
...
I want to create a formula that uses an IF function, and have it apply to

an
entire column. I tried naming the column, and defining the formula, but
nothing happens.



  #3   Report Post  
Old August 1st 05, 11:24 PM
CLR
 
Posts: n/a
Default

One example might be.........

=IF(SUM(A:A)100,SUM(A:A),"")

More specific details would probably yeild something more fitting to your
need.

Vaya con Dios,
Chuck, CABGx3



"Bob Phillips" wrote in message
...
What problem are you trying to solve?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shelly9633" wrote in message
...
I want to create a formula that uses an IF function, and have it apply

to
an
entire column. I tried naming the column, and defining the formula, but
nothing happens.







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
Copy one cell to entire column Tom Excel Discussion (Misc queries) 3 April 28th 05 03:26 PM
Copy one cell to entire column Tom Excel Discussion (Misc queries) 6 April 27th 05 11:39 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Create an if-then formula in Excel to limit column total? Nancy M Excel Discussion (Misc queries) 2 February 13th 05 11:47 PM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 04:43 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017