combination functions in one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

| 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
 
Tiny typo - need to close parentheses after the first A5
If(Sum(A2:A5) >10,Sum(A2:A5),"not met"))
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Creating a formula relating to several cells 2
Error with sum formula in excel 2007 4
formula to make the value in a cell, to a row in a sum function 5
Excel function - countif 2
Help with function 2
Vary sheet name & sum across multiple sheets 3
Excel How to add numbers in same cell? 2

Back
Top