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

D

Dr. Darrell

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
 
C

Connie Martin

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

Dr. Darrell said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF argument limit - how convert formula to VBA? 2
Worksheet name as a variable in VBA 1
Function 6
How do I say… 11
Need a function 1
I need to divide multiple cells by a single control cell in order. 2
Use a wildcard within edit/replace 4
Page numbering with Merged Document and IF statements 1

Top