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!

If(Sum(A2:A510,Sum(A2:A5),"not met"))

HTH

Charles Chickering

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!

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!

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

I think you want this:

=IF(SUM(A2:A5)<10; SUM(A2:A5); 'Not Met')

Rodrigo Ferreira

"mary s" escreveu na mensagem
...
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!

Tiny typo - need to close parentheses after the first A5
If(Sum(A2:A5) 10,Sum(A2:A5),"not met"))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Die_Another_Day" wrote in message
ps.com...
If(Sum(A2:A510,Sum(A2:A5),"not met"))

HTH

Charles Chickering

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!

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!