if statement wont return currency format

[Guest]

Okay, I'm missing something. I have an if statement on a field (negative
partials), properties is set to currency on both fields(partial mrc) and
(negative partials):
Statement:
Negative Partial:
IIf([partial_mrc]<0,[partial_mrc],IIf([partial_mrc]>0,"$0.00"))

In my Negative Partial field it comes over like 83.3367 when it shoud come
across as $83.33.

Thank you for your always on-going help!

 

[fredg]

Okay, I'm missing something. I have an if statement on a field (negative
partials), properties is set to currency on both fields(partial mrc) and
(negative partials):
Statement:
Negative Partial:
IIf([partial_mrc]<0,[partial_mrc],IIf([partial_mrc]>0,"$0.00"))

In my Negative Partial field it comes over like 83.3367 when it shoud come
across as $83.33.

Thank you for your always on-going help!

IIf([partial_mrc]<0,Format([partial_mrc],"#.00"),IIf([partial_mrc]>0,"$0.00"))