View Single Post
  #1   Report Post  
Dr. Darrell
 
Posts: n/a
Default ... 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