having trouble displaying as a percentage

[Novaember]

Hello
I am calculating the accuracy rate and the accuracy rate standard deviations +1, +2, -1 and -2.

My AccuracyRate is 95.16%
The STDevAccuracyRate is 3.76%
(i display these as a percentage)

When I calculate the Accuracy Rate plus 1 standard deviation (STDevAccuracyRatePlus1) I get 98.92% or .9892... (displayed as a percentage)

I don't want the Accuracy Rate +1 and +2 standard deviations to display greater than 100%. The maximum allowed would be 100%. So I wrote:

AccuracyRatePlus1: IIf([STDevAccuracyRatePlus1]>100,"100%",[STDevAccuracyRatePlus1])

This displays .9892... and the property sheet won't allow me to select display as a percentage.

How can I show this as a percentage or write the above statement better?

Thanks in advance for the assistance!
~Nova

 

[DCrake]

AccuracyRatePlus1:Format( IIf([STDevAccuracyRatePlus1]>100,1,[STDevAccuracyRatePlus1]),"Percentage")

Try this

 

[Novaember]

AccuracyRatePlus1:Format( IIf([STDevAccuracyRatePlus1]>100,1,[STDevAccuracyRatePlus1]),"Percentage")

Try this

Hi
When I put that in the result displayed is the word Percentage

It also puts in lots of extra quotes around the word Percentage when I save it. When I enter it there is only one set of quotes around the word Percentage and when I go back to review it after saving there are 3 sets of quotes.

AccuracyRatePlus1: Format(IIf([STDevAccuracyRatePlus1]>100,1,[STDevAccuracyRatePlus1]),"""Percentage""")

 

[Novaember]

Ahhhh! I figured it out!

AccuracyRatePlus1: FormatPercent(IIf([STDevAccuracyRatePlus1]>100,1,[STDevAccuracyRatePlus1]))

that always happens I'm puzzled forever and 10 minutes after I post here I figure it out!

lol