IIf Function

[Guest]

I keep getting error messages with the syntax or commas in my IIf function.
I've listed it as IIf(And([Sq Ft]=>70,[Sq Ft]<=280),1,[Sq Ft]/140). What am I
missing or what have I stated incorrectly?

 

[Guest]

The syntax is incorrect on your And
IIf([Sq Ft]=>70 And [Sq Ft]<=280 ,1,[Sq Ft]/140)

 

[Van T. Dinh]

Is this an Access question or Excel Question?

If it is Access, there is no "And" (spreadsheet) function in Access. You
need to use the And Boolean operator, i.e.

{Boolean expr} And {Boolean expr}