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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Mail Merge - displaying a conditional number of decimals 5
Is this possible? 0
Report Format Creates Error 2
IIF statement format percent 6
Formatting a column 1
new db with 25 items w/ different types of amounts 4
Help to convert merge codes from 2003 to 2010 0

Top