IIF Statement - HELP!

S

susan

I need help with an IIF statement for the following:

If StdPrice = 0, give me "rebill"
If Part# ends with "-OSP",give me "outside processing"

I got the first part to get "rebill" but I can't figure out how to write the
"part# ends with -OSP"...

Please help!
Thanks,
Susan
 
D

Dennis

=IIF([StdPrice]=0,"rebill",IIF(Right([Part#],4)="-OSP","outside
processing","neither rebill nor outside"))
 
S

susan

Thanks Dennis!

Dennis said:
=IIF([StdPrice]=0,"rebill",IIF(Right([Part#],4)="-OSP","outside
processing","neither rebill nor outside"))

susan said:
I need help with an IIF statement for the following:

If StdPrice = 0, give me "rebill"
If Part# ends with "-OSP",give me "outside processing"

I got the first part to get "rebill" but I can't figure out how to write the
"part# ends with -OSP"...

Please help!
Thanks,
Susan
Click to expand...
Click to expand...
 

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

Similar Threads

IIF/UpdateQuery/AppendQuery??? 1
Update except for this list... 2
formula to truncate text characters 6
Nested IIf Branches 2
Option Grp and Field If statement 1
Option Group and If Statement 2
Iif then statement needed for Access 2007 please 5
IIf statement help 3

Top