Formula in Text Box

[Johnthelleader]

I have created the following formula in the Control Source field of a text box using the Expression Builder:

= IIF([GRT]<= 500, "333,000")IIF([GRT]>500,333000+(2500*500)+ (([GRT]-3000)*333))

What I am trying to say is that if the field [GRT]'s value is between 1-500 then the default value is 333000. If it is greater than 500 then the fomula should kick in.



Rearly appreciate anybody's help.

 

[67flyer]

try this code:

=IIf([GRT]<=500,333000,333000+(2500*500)+(([GRT]-3000)*333))

made correction

 

[Mile-O]

Take the " marks out. This returns the default as a string, or as a number. No doubt you don't want the 333,000 as a string.

 

[Johnthelleader]

That's great thanks very much