The number of right facing parenthesis "(" must equal the number of left facing parenthesis ")".
You need a couple more ")" at the right end.

That doesn't make the formula correct however. I believe it should look like this...
=IF(C1C2,C2-C1,IF(C1<C2,C2-C1,""))
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)




"Jennifer"
wrote in message
ng.com...
Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Thank you.

Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Thank you.

Thank you Jim. Tried it and we're close. What I need is to compare
these cells and if the result is a positive number, it should display in
Green font. Or if it's a negative number, it should display in red. If
the cells are equal, the cell should be left blank.

Thanks again.

My teacher is really vague on these formulas.


Jim Cone wrote:
The number of right facing parenthesis "(" must equal the number of left facing parenthesis ")".
You need a couple more ")" at the right end.

That doesn't make the formula correct however. I believe it should look like this...
=IF(C1C2,C2-C1,IF(C1<C2,C2-C1,""))
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)




"Jennifer"
wrote in message
ng.com...
Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Thank you.

You do that with a custom number format...
[Green]General;[Red]General;General

--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)






"Jennifer"
wrote in message
ng.com...
Thank you Jim. Tried it and we're close. What I need is to compare these cells and if the result
is a positive number, it should display in Green font. Or if it's a negative number, it should
display in red. If the cells are equal, the cell should be left blank.
Thanks again.
My teacher is really vague on these formulas.





Jim Cone wrote:
The number of right facing parenthesis "(" must equal the number of left facing parenthesis ")".
You need a couple more ")" at the right end.

That doesn't make the formula correct however. I believe it should look like this...
=IF(C1C2,C2-C1,IF(C1<C2,C2-C1,""))
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)




"Jennifer"
wrote in message
ng.com...
Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))
Thank you.

On Wed, 29 Jun 2011 10:55:06 -0700, "Jim Cone" wrote:

You do that with a custom number format...
[Green]General;[Red]General;General

That should be:

[Green]General;[Red]General;

(Omit the last General, but NOT the last semi-colon, in order to have zero be blank).

To elaborate for Jennifer, your cell containing the formula should contain:

=C1-C2

Then Right Click on that cell and select
Format/Number/Custom Type:
and enter: [Green]General;[Red]General;

Ron Rosenfeld wrote:
On Wed, 29 Jun 2011 10:55:06 -0700, "Jim Cone" wrote:

You do that with a custom number format...
[Green]General;[Red]General;General

That should be:

[Green]General;[Red]General;

(Omit the last General, but NOT the last semi-colon, in order to have zero be blank).

To elaborate for Jennifer, your cell containing the formula should contain:

=C1-C2

Then Right Click on that cell and select
Format/Number/Custom Type:
and enter: [Green]General;[Red]General;

Thank you guys. I appreciate it.