Formatting

P

Pebbs

How can I format the following so the output will be % vs. currency?
=IIf(([Method])="Percent",([Percent]),IIf(([Method])="Amount",([Amount]),''))
 
D

Duane Hookom

How about:
=IIf(([Method])="Percent",Format([Percent],"Percent"),IIf(([Method])="Amount",Format([Amount],"Currency"),Null))
 
Top