Try this:

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

Biff

"mary s" wrote in message
...
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!