Conditional formulas

Resolved · Low Priority · Version 2003

Mon 23 Mar 2009, 16:37 Delegate Hannah said...

Hannah has attended:
Excel Intermediate course

Conditional formulas

How do you do conditional formulas?

Mon 23 Mar 2009, 18:43 Trainer Amanda said...

RE: Conditional formulas

Hello Hannah

Thank you for your question and welcome to the forum.

A conditional formula typically refers to an IF function, so I'm unsure if this is what you would like to know about; or whether you're referring to conditional formatting, which is what we looked at as part of the training today.

If you'd like me to go into further details on either of the above, please post a reply to specify if it's conditional formulas or conditional formatting you're interested in.

Thanks and kind regards
Amanda

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Conditional formulas

Conditional formulas

RE: Conditional formulas

Excel articles

Excel tip:

Sum Up All the Values in A Column