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" 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. |
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. |
All times are GMT +1. The time now is 10:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com