How to write a formula to return a specific value

[Bryan Banker]

I am trying to write a formula that will return a value if a certain number is in that cell.

Example. If cell A2 adds to "0" then show value as "Even". If A2 adds to anything else then show the value as whatever it is.

Thanks

[Pete_UK]

Please check out the Forum Rules at the top of the screen, and change your title, before the mods force you to.

Pete

[Bryan Banker]

Done Pete, I am new here. Thanks!

[Pete_UK]

Okay, you seem to be suggesting that you want A2 to display the word "Even" when the result of a formula in that cell is zero (you say "adds to zero"), so what is in A2? You could have something like:

=IF(your_formula=0,"Even",your_formula)

Hope this helps.

Pete

[Bryan Banker]

Perfect. Thanks for the help!

[Pete_UK]

You're welcome, Bryan - thanks for feeding back.

Pete

[ChemistB]

Clarification please. You want to enter a string of numbers into cell A2 and then have Excel give you a SUM or "Even" in Cell A2? or am I reading this wrong?

[Bryan Banker]

Sort of. In cell A2 it displays a number that was added from a string of numbers. If that number adds up to "0" then I want to display the word "Even". If the numbers is cell A2 add up to 10 then I just wan the formula to display that number.