| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
... 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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage function formula | Excel Discussion (Misc queries) | |||
| One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
| set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
| Non-Breaking Space + Print Issue | Charts and Charting in Excel | |||
Linear Mode
