Formula help please

[Jim Cone]

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(C1>C2,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" <[email protected]>
wrote in message
news:[email protected]...

 

[Jennifer]

Hi,

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

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

Thank you.

 

[Jennifer]

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]

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" <[email protected]>
wrote in message

 

[Ron Rosenfeld]

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;

 

[Jennifer]

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.