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,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" <(E-Mail Removed)> wrote in message
news:5FD2590F-43CD-470A-A4A3-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:5FD2590F-43CD-470A-A4A3-(E-Mail Removed)...
| 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" <(E-Mail Removed)> escreveu na mensagem
news:5FD2590F-43CD-470A-A4A3-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If(Sum(A2:A5>10,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 <(E-Mail Removed)>
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!