expression help

  • Thread starter Thread starter Amy Cooke
  • Start date Start date
A

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#
 
=IF(cell#,200000,cell#*.25,if(cell#=200000,50000,if(and
(cell#>200000,cell#<400000.01),500000,if
(cell#>400000,cell#-350000))))/cell#
.
Click to expand...

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.
 
Back
Top