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.

What problem are you trying to solve?

--

HTH

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


"Shelly9633" <Shelly9633@discussions.microsoft.com> wrote in message
news:A7DD7279-8F19-438A-8208-E8E57F0D11EA@microsoft.com...
> 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.

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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OQ2lILulFHA.3552@TK2MSFTNGP10.phx.gbl...
> What problem are you trying to solve?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Shelly9633" <Shelly9633@discussions.microsoft.com> wrote in message
> news:A7DD7279-8F19-438A-8208-E8E57F0D11EA@microsoft.com...
> > 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.
>
>