Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |