Formatting

  • Thread starter Thread starter Pebbs
  • Start date Start date
P

Pebbs

How can I format the following so the output will be % vs. currency?
=IIf(([Method])="Percent",([Percent]),IIf(([Method])="Amount",([Amount]),''))
 
How about:
=IIf(([Method])="Percent",Format([Percent],"Percent"),IIf(([Method])="Amount",Format([Amount],"Currency"),Null))
 
Back
Top