Access 2013- iif function

[bbatty2001]

I am in an access class and I need to figure out how to write a specific iif function. I need to create a function that charges a 20% discount on jobs above 1000 sq ft. so the function would need to charge regular price up to 1000 sq ft, and apply a 20% discount for jobs above this square footage.
Any help would be greatly appreciated, thanks!

 

[alansidman]

The IIF function syntax looks like this

=IIF(Criteria, Value if True, Value if False)