#error in my IIF statement (currency issue)


R

robert

I've had too much to drink tonight and my wife doesnt want to have sex
with me :(
but it's broken my concentration and I cant get my IIF statement to
work. I'm tyring to setup an iif where iff the AMOUNTPAID colunm
equals a certain number, then the expression returns "A Positive
REsult","or a negative result" and it gives me the #error, here we go:

iif([amountPAID]="500","1000","1200")

returns #error

The amountPAID column is a currency column what "strings" do I use?
Thanks to anyone in advance.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top