- Joined
- Apr 4, 2003

- Messages
- 19,786

When I try those examples in Excel it gives me errors. Am I not suppose to use the Curly Braces?Adds a plus sign to a positive result, a minus sign to a negative result, or a space if the result is 0 (zero). For example, { = 100 - 90 \# +## } displays "+10", and { = 90 - 100 \# +## } displays "-10".

Basically what I am trying to do is take the number in column B, subtract it from 200 and put a plus sign in front of it, if it is a positive number.

How do I change this formula so that the output will put a plus sign in front of the output.

=(B2-200)

Basically what I really want the output to do as well is print

**EVEN**if the result is equal to zero, but I could live without that feature. So I would really like to have the output like this.

-10

EVEN

+10