if statement wont return currency format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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