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

[Guest]

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))
What is the correct Syntax for my application?

Thanks,
Darrell

 

[Guest]

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

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))

What is the correct Syntax for my application?

Thanks,
Darrell

 

[Guest]

Connie:

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

TY
Darrell