... I want to print $0.00 if ...
 

In cell C10, I have a math function <<< C8-C9 .

If C9 is bigger than C8, I want the result to be printed as $0.00.

I thought the proper Function should be types as <<< =IF(C10<0,0(C8-C9))
, but Excel is not accepting this.

What is the correct Syntax for my application?

Thanks,
Darrell

In cell C10, try: =IF(C9C8,0,(C8-C9))

"Dr. Darrell" wrote:

In cell C10, I have a math function <<< C8-C9 .

If C9 is bigger than C8, I want the result to be printed as $0.00.

I thought the proper Function should be types as <<< =IF(C10<0,0(C8-C9))
, but Excel is not accepting this.

What is the correct Syntax for my application?

Thanks,
Darrell

Connie:

It's amazing what a small comma will do for you!!!

TY
Darrell

"Connie Martin" wrote:

In cell C10, try: =IF(C9C8,0,(C8-C9))

"Dr. Darrell" wrote:

In cell C10, I have a math function <<< C8-C9 .

If C9 is bigger than C8, I want the result to be printed as $0.00.

I thought the proper Function should be types as <<< =IF(C10<0,0(C8-C9))
, but Excel is not accepting this.

What is the correct Syntax for my application?

Thanks,
Darrell