IIf Function

M

mkb

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?
 
K

Klatuu

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

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}
 
Top