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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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!