formula for this text box

[Pyscho]

I have a text box with this formula in (its for the parking fee):

=([pToDate]-[pFromDate])*IIf([Sitename]=Orange site,4.5,9)

But it keeps returning an error. The pToDate-pFromDate work fine, they just count the number of days, but it should mulitiply this by £4.50 if sitename is Orange site, otherwise £9.00.

Note: Sitename can only be 'Orange site' or 'Green site'.

Where am i going wrong, please someone help me, thanks.

 

[FoFa]

"Orange Site"

 

[llkhoutx]

Try

=([pToDate]-[pFromDate])*IIf([Sitename]="Orange site",4.5,9)