Format Value within iif statement

A

alecgreen

Hi

I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.

Mant Thanks

Alec
 
P

pietlinden

Hi

I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.

Mant Thanks

Alec
Click to expand...

use the Format function inside your expression.
 
D

Dennis

A

alecgreen

Margin%: IIf([value]=0,"****",Format(([Value]-[StdCost])/[Value]*100,"0.00"))



alecgreen said:
Hi
I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.
Mant Thanks
Alec
use the Format function inside your expression.
Click to expand...
Click to expand...
not sure how to do this, could you explain further please!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks for that, works a treat!
 
Top