IIf Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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