mary

=IF(SUM(A2:A5)=10,"not met",SUM(A2:A5))


Gord Dibben MS Excel MVP

On Thu, 21 Sep 2006 11:02:02 -0700, mary s
wrote:

Hi

I am trying to create a combination function. I want to first sum specific
cells in a column and then if the sum is a certain value, I want the cell to
say "not met" instead of the sum.

For example, I want to put the formula into cell A1. I want to sum A2:A5.
The value is 10. Instead of the true value, the cell should say "not met".
However, if the value is anything other than 10, the cell should show the
correct sum. Is this possible?

Thank you!