How do I create a formula for an entire column

G

Guest

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.
 
B

Bob Phillips

What problem are you trying to solve?

--

HTH

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

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Help needed 0
How to apply the same formula to an entire column 5
Delete a formula but leave the data. 2
Create Function For Entire Column Indefinitely 1
COLUMN FORMULA 1
Changing A Column Of Text numbers To True Numbers: How ? 2
How can I refer to an entire column? 4

Top