expression help

[Amy Cooke]

I'm trying to convert this excel expression over to
access. Can anyone help?

=IF(cell#,200000,cell#*.25,if(cell#=200000,50000,if(and
(cell#>200000,cell#<400000.01),500000,if
(cell#>400000,cell#-350000))))/cell#

 

[JL]

=IF(cell#,200000,cell#*.25,if(cell#=200000,50000,if(and

(cell#>200000,cell#<400000.01),500000,if
(cell#>400000,cell#-350000))))/cell#
.

Simply replace "IF" with "IIF" should do the trick.
Of course, "cell#" will be replace with the table field
name. You also have to rewrite the and statement as well.